Episode 103 – The Road to MBAS

This is episode 103 recorded on June 7th, 2019 where John & Jason talk about the Microsoft Community, plans for the Microsoft Business Applications Summit, a few bits of news, and some recent helpful blog posts from John.

Show Notes

Microsoft Business Applications Summit

Connect to Power BI dataflows and datasets using Power BI Desktop with multiple accounts

Connecting Power BI workspaces and SharePoint sites

User Voice Picks

John:

Make OneDrive a default Get Data connector

Please add a OneDrive data source option in Power BI.

It is incredibly frustrating that Power BI does not come with a OneDrive for Business option baked in and is especially strange since OneDrive belongs to Microsoft. It seems like this would have been present in the application from Day 1.

Having to manually locate a file outside of Power BI, identify the correct URL for the file in a OneDrive account, and then having to plug that in to Power BI is unnecessarily convoluted and is particularly difficult for new Power BI users to manage.

Jason:

Prompt the User Before Creating a Hierarchy When Fields are Dragged Onto Each Other

How many times have you dragged a field onto another field by mistake and have it create a hierarchy?

It happens quite often. Usually I am trying to drag the field to the Visualization pane but fail to hold the mouse button. And lo and behold it creates a hierarchy. (Which I then have to delete. But sometimes I do not even notice that I accidentally created a hierarchy).

It would be nice if a prompt came up, asking if we want to create a Hierarchy

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36626470-prompt-the-user-before-creating-a-hierarchy-when-f

Episode 98 – Live from SPFest DC 2019

This is episode 98 recorded on April 2nd, 2019 where John & Jason talk to Treb Gatte, Managing Partner at Tumble Road, about all the exciting Power BI news from the last couple of weeks. 

Show Notes

E-Mail Subscriptions for Paginated Reports is Now Available

E-Mail Subscriptions for Paginated Reports is Now Available

Announcing Query Caching in Power BI Premium

Skip Test Connection for On-premises and Cloud Data Sources

Announcing Power BI Home General Availability (GA) & Roadmap

Power BI Dataset data source support for Paginated Reports is now available

Exporting the workspaces list from the Admin Portal

Duplicating workspaces by using Power BI cmdlets

Episode 82 – 2018 Power BI Wrap Up

This is episode 82 recorded on December 18th, 2018 where John & Jason talk about the highlights of 2018 in the Power BI space & make some predictions for 2019.

Show Notes

Favorite features list:

Show/Hide pages (Jan)
Desktop in the Windows store (Feb)
Slicer sync (Feb)
Persistent filters (March)
Report page tooltips (March)
Bookmarking (March)
Action/Bookmark buttons (April)
Q&A Explorer (April)
Incremental Refresh (May)
New “From Web” Connector (May)
Composite models (July)
SharePoint Roadmap – July
New workspace experience (August)
Monitoring app for Premium (August)
Printing (August)
Aggregations (September)
New Power BI Home (September)
M Intellisense (September)
DAX Editor (October)
Dataflows (November)
New modelling view (November)
Paginated reports (November)
Copy/Paste between Desktop Files (Nov)
Smart guides (Dec)
External Dataflows (December)

Episode 81 – Interview with Andrew Connell

This is episode 81 recorded live at SharePointFest Chicago on December 6th, 2018 where Jason talks Andrew Connell, co-host of the Microsoft Cloud Show and Instructor & Entrepreneur at Voitanos.io, about Azure AppInsights & developing for proper analytics.

Show Notes

Andrew Connell is a full-stack web developer and 12-time annual recipient of the Microsoft MVP Award for Office Development, Office Servers and Services with a deep developer background in SharePoint, Office 365, and Microsoft Azure. He has spoken at various conferences around the world including Microsoft’s TechEd, BuildIgnite & SharePoint conferences, Angular’s ngConfAngularUSPTechConSP Live360 among many others. He’s taught hundreds of people via in-person & online classroom based training for over 10 years including through the training company Critical Path Training he co-founded & co-operated for four years (2009-2013). Additionally, he has a catalog of on-demand video-based training available through Pluralsight. Microsoft has hired Andrew multiple times to present at internal conferences such as TechReady, develop, deliver and publish training courses and to serve as a key strategic and technical advisor to multiple internal product teams.

Over the years Andrew has proven himself time & time again as an experienced technical trainer and course author. Building on this vast experience, he is excited to bring it direct to you to provide the ideal learning experience.

Voitanos is where you’ll find Andrew’s self-hosted video-based on-demand technical training courses and educational resources.

The Microsoft Cloud Show

The only place to stay up to date on everything going on in the Microsoft Intelligent Cloud world including Azure and Office 365. 

Whether you are new to the cloud, old hat or just starting to consider what the cloud can do for you this podcast is the place to find all the latest and greatest news and information on what’s going on in the cloud universe.  Join long-time Microsoft aficionados and SharePoint experts Andrew Connell and Chris Johnson as they dissect the noise and distill it down, read between the lines and offer expert opinion on what is really going on.  Just the information … no marketing … no BS, just two dudes telling you how they see it.

Episode 75 – PASS Summit News & Dataflows

Thisis episode 75 recorded on November 9th, 2018 where John & Jason talk aboutthe news coming out of PASS Summit and break down the introduction of Dataflows.

Show Notes

Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop

https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/

  • Dataflows expand self-service data prep in Power BI
  • SQL Server Reporting Services technology now in Power BI
  • Power BI Desktop November Update
    • Will cover in detail on a future show once this drops

Introducing: Power BI data prep with dataflows

https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

  • Self-service data prep for big data in Power BI 
  • Advanced Analytics and AI with Azure
  • Support for the Common Data Model
    • Getting started with self-service data prep
    • Ingesting large amounts of data with Incremental Refresh
    • Building complex ETL projects with Linked entities
  • Gaining further insights with Computed entities
    • Connecting datasets to your data

Public Preview of Paginated Reports in Power BI Premium Now Available

https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available

Power BI Paginated Reports also available in Power BI Mobile Apps(preview)

https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview

Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app

https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/

Premium Capacity Metrics app – query metrics histogram now available

https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/

 

Episode 74 – Interview with Amir Netz

This is episode 74 recorded on September 24th, 2018 where John & Jason interview Amir Netz, Technical Fellow and Chief Architect of Microsoft BI offerings at Microsoft, about all things Power BI.

Show Notes

About Amir
https://news.microsoft.com/stories/people/amir-netz.html

Elly Gotz’s story
http://fortune.com/2018/11/01/pittsburgh-synagogue-shooting-holocaust/?fbclid=IwAR2SdrRuhIWYVRhH8-vsEmHVfhQ-VLmP7udG0wHsHHVuMpdmKkKn0NovK9s

Chris Finlan’s blog post: “Export to PowerPoint is now generally available and looking ahead at what’s coming next”
https://powerbi.microsoft.com/en-us/blog/export-to-powerpoint-is-now-generally-available-and-looking-ahead-at-what-s-coming-next/

Last week’s interview with Chris Finlan
https://www.bifocal.show/2018/10/30/episode-73-interview-with-chris-finlan/

Episode 73 – Interview with Chris Finlan

This is episode 73 recorded on October 22nd, 2018 where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the Power BI Report Server, Paginated Report in the cloud via Power BI, and much more.

Show Notes

Power BI Report Server release timing update

Chris Finlan on Twitter

PASS Summit (Focus Groups)

Episode 65 – Meetup with Reza Rad

This is episode 65 recorded on September 11th, 2018 where John & Jason talk to Microsoft MVP and Regional Director Reza Rad about Reza’s Power BI background, and our joint meetup at Microsoft Ignite.

Reza Rad is an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for seven continues years (from 2011 till now) for his dedication in Microsoft BI. Reza is author of Power BI from Rookie to Rock Star and some other books. He is training and consulting on Microsoft BI and Data Analytics technologies.

Show Notes:

Meetup at Ignite with John, Jason & Reza
https://myignite.techcommunity.microsoft.com/sessions/66510

RADACAD
radacad.com

Power BI Helper
http://radacad.com/power-bi-helper

Upcoming Events

Microsoft Ignite 9/24-9/28 
https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29
https://www.sharepointeurope.com/

SharePointFest Chicago
https://sharepointfest.com/Chicago/

SPTechCon Boston – February 10 – 13, 2019
https://www.sptechcon.com/west 

North American Collaboration Summit – March 14 – 16, 2019
http://www.collabsummit.org/

SPFest DC – April 29 – May 3, 2019
https://sharepointfest.com/Chicago/

SharePoint Conference 2019 – May 21 – 23, 2019
http://www.sharepointna.com

Eurpoean Collaboration Summit – May 27 – 29, 2019
http://www.collabsummit.eu



Episode 59 – Interview with Will Thompson

This is episode 59 recorded on July 31st, 2018 where John & Jason talk about SharePoint Saturday NYC, sessions for Microsoft Ignite, and interview Will Thompson from the Power BI Desktop Team at Microsoft.

Show Notes:

Intro to Power BI Desktop – Will’s session from Business Application Summit 2018

Power BI Desktop July 2018 Release

Power BI and the Future for Modern and Enterprise BI (Business Application Summit 2018)