Episode 112 – Changing the Laws of Physics with Christian Wade

This is episode 112 recorded on August 7st, 2019 where John & Jason talk to Christian Wade, Senior Program Manager for Analysis Services at Microsoft, about Power BI in the Enterprise, the updates to Aggregations feature, upcoming major performance enhancements, and more.

User Voice Picks

Jason

Customize visible items in new filter experience

The standard slicers have now a visual level filter, but the new filter experience does not have a similar feature. A correspondent “visual level filter” allowing to define conditions that make an item visible or not. in the new filter experience. The reasons are the same that justified visual level filter in standard slicers.

John

Hyperlink in Visuals

You should be able to insert a hyperlink field into a visual so when a user selects on the visual, it can take them to the desired page.

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

Power BI Licensing and the Power BI Web Part in SharePoint

John White recently published a couple of posts to help clarify the licensing requirements around the Power BI web part for SharePoint. The first, “What License is Needed to Use the Power BI Web Part?” deals with the nuances of using Power BI Pro vs the Premium licensing model.

The second, “Power BI Embedded is not for Embedding Power BI Reports” discusses the Premium model in Power BI Embedded, and why it’s not appropriate for use with SharePoint.