Episode 76 – Power BI Desktop’s Biggest Update

This is episode 76 recorded on November 21st, 2018 where John & Jason talk about all the new stuff in the latest Power BI Desktop like the updated filtering experience & the new modeling view now in preview.

Show Notes

Reporting

• Expand & collapse matrix row headers
• Copy & paste between Desktop files
• Updated filtering experience (preview)
• Report accessibility improvements

Analytics

• Color saturation on visuals upgraded to use conditional formatting
• Related questions in the Q&A explorer

Modeling

• New modeling view (preview)
• Composite models now generally available
• Modeling accessibility improvements
• New DAX functions
  • Optional DrilldownFilter argument for the RollupAddIsSubtotal function
  • NonVisual function
  • IsInScope function

Custom visuals

• Calendar by MAQ Software
• Ratings by MAQ Software
• Hourglass Chart by MAQ Software
• Forecast Using Multiple Models by MAQ Software
• Pie Charts Tree

Data connectivity

• Azure DevOps Server connector
• PDF Connector support for Start Page and End Page parameters
• Improved Azure Consumption Insights connector

John’s blog posts

Use Power BI dataflows to warehouse SharePoint list data

https://whitepages.unlimitedviz.com/2018/11/power-bi-dataflows-sharepoint-list-data/

Getthe most out of Power Query in Power BI Dataflows

https://whitepages.unlimitedviz.com/2018/11/most-power-query-power-bi-dataflows/