Hey all – John here. One of the things that we get asked frequently is how to report on SharePoint data. The answer is of course, “well, it’s easy, but it depends”.
In the spirit of clearing up the “it depends” part, I’m in the process of writing a series of articles that walks through the nuances of the various SharePoint complex data types. The first one shows some options for reporting on multi-value SharePoint columns, and includes tricks that pertain to more sources than just SharePoint.
You can find the post here. Enjoy!
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
EDX Power BI Course
John & Jason’s upcoming events
SharePointalooza\North American Collaboration Summit
March 2-3, 2018
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
This is episode 30 recorded in January 1st 2018… where John & Jason talk about the news from the past few weeks in Power BI, Office 365, and Azure.
On-premises data gateway December update
-includes a number of bug fixes and improvements to previously released features
-matches the Mashup Engine that was released as a part of the Power BI Desktop December update
Sync members from O365 Modern group to a mail-enabled security group
-This is one of the issues that we run into because Power BI is NOT a part of Office 365
-The solution that Adam shows is a viable, one time solution but does not solve the longer term issue
-This can be scripted to run daily, but it is duplicating groups at that point which will ultimately cause problems
-We love Adam Saxton & Patrick LeBlank and recommend people subscribe to the YouTube Channel GuyInACube
-We don’t actually recommend you do this…
The Reddit Solution Template
-Point solution for Reddit
-Similar solutions exist for Twitter, Facebook, & Bing News
-What are Solution Templates anyway?
-Who is this for? Social Media Managers… that use Reddit
Server aliases for Azure Analysis Services
-Aliasing is always a good idea
-easier to remember
-obfuscates actual server information
-allows the use of Azure Traffic Manager
-Users can connect to the server from Power BI Desktop (in addition to other client tools) using the link:// format
Azure Analysis Services integration with Azure Diagnostic Logs
-Various scenarios are supported, including the following:
-Monitoring of server health
-Derivation of usage metrics
-Understanding which user groups are using which datasets and when
-Detection of long-running or problematic queries
-Detection of users experiencing errors
-Consume diagnostic logs in Power BI
-give you a text file that contains an M expression, which can be pasted into a blank query in Power BI Desktop
-The expression contains the current Log Analytics query and consumes from the Log Analytics REST API