Episode 121 – October 2019 Power BI Desktop Update & News

This is episode 121 recorded on October 15th, 2019 where John & Jason talk about the October Power BI Desktop features including Automatic page refresh for Direct Query, the new Q&A visual and associated updates, and Query diagnostics.

Show Notes

Reporting

Analytics

Visualizations

Data connectivity

Data Preparation

Template Apps

Other

User Voice Picks

Jason

Auto refresh the report

A PBI report is showing 7*24 hours (Full Screen). Now the data gateway has been finished the refreshing. But the data on the report is not be changed. Looks like it is a static page. I must manual refresh. So it is not automatic. Hope enable the report to auto refresh.

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)”.

https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/hide-an-item-report-builder-and-ssrs?view=sql-server-2017

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 this item.

Episode 120 – October 2019 News Roundup

This is episode 120 recorded on October 2nd, 2019 where John & Jason talk about the Microsoft Ignite schedule builder and a whole bunch of news items from the last month.

Show Notes

Power BI Report Server September 2019 Feature Summary

Template apps update (preview) is now available

Paginated Reports in Power BI September 2019 Feature Summary

Power BI Dataflows September 2019 Feature Summary

Announcing the Microsoft Business Applications October Virtual Launch Event

URL parameters for Paginated Reports are now available

What’s new for SQL Server 2019 Reporting Services RC1

What’s new for SQL Server 2019 Analysis Services RC1

User Voice Picks

Jason

The ability to message all Power BI users from the Power BI service

If you run a Power BI platform for a lot of users you should be able to send /push notifications to them. We are currently experiencing high fail rates and it would be great to alert all users that we’re busy looking into it.

John

Support creating calculation groups in Power BI Desktop

Support the creation of DAX calculation groups in Power BI Desktop – otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.

Even just a simple text window with a script would be fine. You can clean up the UI later.

Thanks.

Episode 119 – Power Platform 2019 Roadmap Wave 2 Plan

This is episode 119 recorded on September 27th, 2019 where John & Jason talk through the Microsoft Power Platform 2019 Release Wave 2 Plan and highlight the important Power BI dates over the next few months.

Show Notes

Power Platform Wave 2 Release Plan Document

Power Platform Admin Center

Power BI Features Release Dates

User Voice Picks

John

Connect PBI Desktop to multiple PBI Online Datasets

Currently, once you connect to a Power BI Service/Online Dataset you cannot add additional data sources. We have several datasets we’d like to put in the same report, but can’t because they are over the 1GB limit on size. If we could live-connect to them all in Power BI Desktop this would help.

Jason

Images should have Locked Aspect Ratio

When I add an image to Power BI Desktop, the default setting is that the Aspect Ratio is not locked. This makes the process of scaling the image to a suitable size behave in an inconsistent way compared to (say) PowerPoint. If you turn on “lock aspect ratio”, then the image scales correctly and consistently with other office applications.

Most images should be scaled with a locked aspect ratio.