Power BI Insights: Processing Analysis Services tasks; Columns in models; SharePoint imports; Field Finder

Power BI pros share insights on visualizing Analysis Services tasks, which columns appear in data models, importing files from SharePoint and using the Field Finder.

Visualizing processing Analysis Services tasks

Chris Webb shared his excitement about a new Profiler event type in Power BI Premium Gen2. Job Graph allows visualization of Azure Analysis Services processing jobs. Initially, data returned by Job Graph is almost impossible to make sense of in Profiler. But Webb explained that users can export Job Graph event data as XML, then rely on Gantt charts in HTML or create DGML diagrams in Visual Studio.

Webb generated a DGML diagram showing nodes in a semi-circle representing eight jobs processing in the attribute hierarchy table, and with critical path node marked in black.

He wrote:

I think this is going to be really useful when I’m troubleshooting processing performance problems. It would also be really cool to have this in DAX Studio (hint, hint)…

Figuring out what columns are left out of a Power BI data model

FREE Membership Required to View Full Content:

Become a MemberLogin

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates. 
Learn more about us here