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
https://azure.microsoft.com/en-us/blog/import-power-bi-desktop-files-into-azure-analysis-services/

Kasper’s trick to repoint the PBIX
https://www.kasperonbi.com/change-your-power-bi-report-to-point-to-an-external-ssas-model/

Importing from PBI Desktop to SSAS On Prem – BIInsight
http://biinsight.com/import-power-bi-desktop-model-to-ssas-tabular-2017-using-azure-analysis-services/

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