Episode 32 – Size Matters

This is episode 32 recorded on January 11th 2018… where John & Jason talk about scaling Power BI, it’s limits, and how to overcome them.

iTunes ratings contest

We are actively trying to get our visibility up for the show and one way to accomplish that is through having ratings on iTunes. To that end, we are asking out listeners to take a moment and rate us on iTunes. Once we hit 10 reviews, hopefully before our Feburary 6th show, we are going to raffle off a $50 Amazon gift card to one of the people who rated us. You will need iTunes to be able to do it, but you can find our page here: https://itunes.apple.com/us/podcast/bifocal-clarifying-business-intelligence/id1266308225 

Size & Scale

What are the limits & why?

Free vs Pro vs Dedicated Capacity storage limits by licensing

App Workspaces vs Office 365 Groups vs Teams confusion

Personal storage limit in Power BI is 10GB per user & per Office 365 Group/App Workspace

Personal storage limit in Power BI is 1GB per model

Maximum size of a single data model limit in Dedicated Capacity is now 10GB
-does NOT go against the user’s personal storage limit

Episode 10 – May I see your license please sir?

Moving a PBIX file to AAS

Load your data model to AAS

Kasper’s trick to repoint the PBIX

Importing from PBI Desktop to SSAS On Prem – BIInsight

Other Stuff to check out

Chris McNulty’s post on Tech Community

SPSEvents site

EDX Power BI Course

John & Jason’s upcoming events

SharePointalooza\North American Collaboration Summit
March 2-3, 2018
SharePointFest DC
March 26-30, 2018
SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off
European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Episode 31 – Power BI Desktop January Update

This is episode 31 recorded on January 9th 2018… where John & Jason talk about the January features updates to Power BI Desktop, some things they noticed in the Desktop client, and some User Voice submissions.


Show and hide pages
Control data label background color for Cartesian and maps visuals
Increase area used for axis labels in charts
Bar/column padding control
Show dates as a hierarchy (preview)
Add an anchor date for relative date slicer
Top N selection in Q&A


Correlation coefficient quick measure

Custom Visuals

Funnel with Source by MAQ Software
Box and Whisker chart by MAQ Software
Agility Planning Matrix Light
Image Grid
Gantt Chart by MAQ Software

Data connectivity

Support for Azure Active Directory authentication for Azure SQL Database & Data Warehouse connectors


Advanced language settings for the Windows store app

Power BI Desktop things of note

-Help tab
-Windows Store download was behind the blog post

Previous Month’s Power BI Desktop update episode

Upcoming events

SharePointalooza\North American Collaboration Summit
March 2-3, 2018
SharePointFest DC
March 26-30, 2018
SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off
European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Power BI User Voice submissions



Episode 29 – 2018 Predictions from the Community

This is episode 29 recorded in December 2017… where John & Jason talk to community members about their 2018 predictions & make a few themselves.

A special thank you to Dan Holme for supporting us in this reimaging of his Penton series of Predictions. This was always a fun series of predictions to read, and we hope that you find this episode entertaining to listen to.

Thanks to everyone who contributed a prediction for 2018. Follow them on Twitter and check out their blogs below:

Andy Huneycutt – 5:15


Brian Alderman – 7:16


Christina Wheeler – 7:38


Marc D Anderson – 8:20


Chris McNulty – 9:45


Dean Swann –  10:46


Joanne Klein – 11:40


Jeremy Thake – 12:28


Susan Hanley –  12:57


Mark Rackley – 13:10


Mike Fitzmaurice – 13:48


Andrew Connell – 14:48


Vlad Catrinescu – 15:48


David Broussard –  16:02


Richard Campbell – 17:10



We wish everyone a happy holiday season and a Happy 2018!


Episode 27 – A chat with Paul Schaeflein on Power BI & Microsoft Teams

This is episode 27 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk to Paul Schaeflein about helping people transform applications using Microsoft Teams, authentication stuff using Azure B2B & Paul quizzes us on how people should be using Power BI.

Paul Schaeflein is a solution architect/developer with more than three decades experience in architecting, designing and developing software solutions. This experience covers a vast range of technologies, languages and industries. Paul is an independent consultant, helping organizations of all sizes with their application development, ALM and SharePoint/Office 365 projects. Paul is a top-rated speaker, having presented at SharePoint Evolutions, the Microsoft SharePoint Conference and TechEd conferences, as well as user groups. In recognition of these community efforts, he is recognized as a Most Valuable Professional (MVP). Paul has a blog at http://www.schaeflein.net/blog, and is active on Twitter as @paulschaeflein. You can also reach him at paul@schaeflein.net.

Find out more about Paul at https://www.schaeflein.net/speaker-biography/

Helpful links:

The webinar for B2B (and Flow): https://www.youtube.com/watch?v=AIImcUZyP7U

SharePoint Conference NA: https://www.sharepointna.com use discount code SCHAEFLEIN

Power BI Report Server episode with Chris Finlan

Episode 26 – OnPrem Data Gateway & Power BI Developers news

This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.


Technical reference implementation for enterprise BI and reporting

On-premises data gateway November update is now available

  •     The public preview of the long-awaited High Availability support.
  •     The “Additional Logging” setting of the gateway will now include the Mashup engine traces.
  •     The gateway will now automatically fall back to communicating through Azure Service Bus using HTTPS if direct TCP fails.
  •     The gateway now includes the November version of the Mashup engine.

Power BI Developer community November update

Azure Resource Manager API

  • Scale up/ down
  • Pause/ start resource
  • Create/ Delete resource
  • Get capacity information
  • Update capacity
  • Get capacity list in a resource group/ subscription

….they will add support for ARM PowerShell soon

Cloud Service Provider purchase channel now available

Visual Options menu and Context menu extension

Injecting custom actions into the options & context menus

Preload API for a better loading experience

Update connection string

RLS support on AS Azure for pre-defined roles

API 1.9 is now available, adding the ability to open the default browser and navigate to a URL

How to clone workspaces using the API

Microsoft’s best practices for building custom visuals in Power BI

Episode 25 – Power BI Guest Access

This is episode 25 recorded on November 24th, 2017… Black Friday… or as we call it, Analytics Friday… where John & Jason talk about Power BI Guest Access using Azure B2B and some tips, tricks & community shout outs.



Guest Access now available


  • AAD B2B with Power BI is available starting today.  Read the documentation and try inviting an external user now!
  • For more information and a step-by-step guide to distributing BI content with Power BI and Azure AD B2B read this whitepaper. Also visit Azure documentation for more information on Azure AD B2B.


-Power Query Tip – Cached data remembers its source – even after you change it in the Query Editor. You need to make sure it’s totally refreshed.

-Facebook Query has totally changed: https://whitepages.unlimitedviz.com/2017/11/facebook-location-tracking-power-bi/


Community shout outs

DigiCert: https://www.digicert.com/

Pluralsight: https://www.pluralsight.com/

RunAs Radio: http://www.runasradio.com/Shows/Show/559

Richard Campbell: https://twitter.com/RichCampbell

Episode 24 – November’s Power BI Desktop update & more

This is episode 24 recorded on November 17th, 2017… where John & Jason talk to about the latest Power BI Desktop update, some new custom visuals, and some community contribution picks.

Power BI Desktop November Feature Summary


Stuff John is excited about in November’s Power BI Desktop

  • Rule based conditional formatting in tables
  • Cell alignment for tables
  • Visual ordering in the selection pane (z-order)
  • Lock report objects !!!!!!!
  • ESRI Plus subscription available….
  • Report options for slow data sources in Direct Query (good, but….)
  • New visuals – Image timeline, Social graph, Venn diagram, HTML viewer

Here’s the complete list of November updates:



Data connectivity – Single Sign-on

Impala connector – support for Windows Authentication
check out Episode 23 for more on SSO

Query editing

Add Column From Examples improvements

Community forum stuff:

Cool infographic that shows what is what in the Power BI space (features w/ license requirements)


Power BI Desktop terminology & definitions

New Office 365 launcher showed up

Flow – Calculate running totals

Stacy Simpkins (@sharepointstacy) blog post about migrating SSRS from one SharePoint farm to another