Episode 110 – All About Ignite with Anna Chu

This is episode 110 recorded on July 25th, 2019 where John & Jason talk to Anna Chu from Microsoft about all of the opportunities available for community participation at this year’s Microsoft Ignite Conference.

Show Notes

Microsoft Ignite 2019

Microsoft Ignite 2019 call for community content

Microsoft Ignite 2019 call for community champions

Microsoft Ignite 2019 call for community reporters

Episode 109 – Interview With Reid Havens

This is episode 109 recorded on July 18th, 2019 where John & Jason review some community news, and John interviews Reid Havens of Havens consulting about the Power BI community, consulting in the Power BI world, and template apps.

Show Notes

Matt Allington’s post on scaling capacity up and down

Phil Seamark’s post on speeding things up if you use “contains” in DAX

Phil Seamark’s post on speeding up DirectQuery

Guy In A Cube – No code REST APIs

User Voice Picks

John

Support AVRO file format

It would be great if Power BI could read files in AVRO format from Azure Blob Storage

Jason

Allow ‘Search’ within slicer filtering for non-text attributes

Text attributes can be ‘searched’ within report slicers. However, integers cannot. For example, if someone wants to quickly find and slice by a Customer Id, it is very cumbersome right now – lots of scrolling. A simple search by Customer Id (as an integer) within the slicer would make it much faster and a better user experience

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