Episode 122 – October 2019 news roundup

This is episode 122 recorded on October 29th, 2019 where John & Jason talk about the October Power BI news including refreshing your Power BI dataset using Microsoft Flow, general availability of  Automated Machine learning in Power BI, and the Power BI lineage view.

Show Notes

Introducing Power BI lineage view

Announcing Automated Machine learning in Power BI general availability

Announcing new contact lists for reports and dashboards in the Power BI service

Refresh your Power BI dataset using Microsoft Flow

Keep your Power BI SharePoint reports current with Microsoft Flow

User Voice Picks

John

Allow Pro Users to Publish RDL files from Report Builder

The current version of the report builder can only be published by premium capacity accounts. It would be awesome to include this feature for pro users as well and allow us to add paginated reports to our apps we develop. We have a flat organizational structure and tend to use power BI for clients. We all have pro licenses but there is not much sense to buy premium capacity at this time. However, having this feature would be a huge benefit to everyone using power bi under pro accounts.

Jason

Ability to BLOCK self-service purchase capabilities for Power Platform products

Message centre update refers : MC193609 Self-service purchase capabilities for Power Platform products (Power BI, PowerApps, and Flow) will be available for commercial cloud customers starting 11/19.

We need the ability to block this on tenant level with immediate effect. The platform will become ungovernable in a very short period and cause massive governance issues.

Episode 108 – Interview with Justyna Lucznik

This is episode 108 recorded on July 12th, 2019 where John & Jason interview Justyna Lucznik, Program Manager on the Microsoft Power BI team, about the Machine Learning abilities in Power BI, the announcements around AI & ML at MBAS and what is still to come.

User Voice Picks

Justyna

Ability to execute R and/or Python scripts on data model data in DAX expressions

Expose a generic function in DAX that takes R/Python script as a parameter to run on data model data. This enables real advanced analytics in Power BI.

Jason

Add labels to Key Influencers

1. Add data labels to Key Influencers so we can see which data points are the outliers.

Currently, the only way to know is to filter categories out, or to do a scatter plot of the 2 variables under consideration. Not practical when having many key influencers.

2. Add color and size options for the graphical view of the influencers, similar to the Scatter Plot visual

-OR-

3. Add the ML capability to show clusters in the data, in addition with the awesome decision tree for the top segments.

John

Machine Learning Models for Pro Users

Please extend Machine Learning capabilities to pro users. Small to Medium sized business may not have the employee count to justify enterprise licenses, but we can still benefit from general capability advancements in the Power BI service/product offering.