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
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