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.

Episode 107 – Power BI News and MVP Renewals

This is episode 107 recorded on July 2nd, 2019 where John & Jason talk about MVP Renewals, the World Cup, and a whole bunch of Power BI News including the New Viewer Role for Power BI workspaces, the June dataflows updates, and a new version of Power BI Report Builder.

Show Notes

Power BI Dataflows June 2019 Feature Summary

Announcing the New Viewer Role for Power BI Workspaces

Introducing dataflow templates; A quick and efficient way to build your sales leaderboard and get visibility over your sales pipeline

Avoiding workspace loops by expanding navigation properties in the GetGroupsAsAdmin API

Power BI Paginated Reports June 2019 Feature Update Summary

Announcing support for non-Premium Power BI datasets in Power BI Paginated Report Builder

User Voice Picks

Jason

Power BI Desktop: Option to use either light or dark interface

New Desktop app update installed an almost white user interface. There is zero contrast which is not good for the eyes. I see where some people have requested a light interface so incorporate an option to select either light or dark theme like in the Office apps.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37882726-option-to-use-either-light-or-dark-interface

John:

Visibilty (Hide an Item)

Develop an item formatting property which allows to set the visibility of a report item when you want to conditionally hide the item based on a report parameter or some other expression that you specify (also DAX expressions).

You can develop this incrementally starting from visuals, then text boxes, then shapes and buttons….

If you want to go the extra mile, you can also develop a functionality that allows the final user to toggle the visibility of report items.

For more information and since it was an available and really useful capability see “Add an Expand or Collapse Action to an Item (Report Builder and SSRS)”.

I double checked in the ideas database and there are many ideas describing the same functionality; this is the reason why I do believe this is really required and will try to collect all the previous votes under

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item