BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
There's not much new in this month's update. The Performance Analyzer is a great idea, for working out which bits of your report are running slowly, but all of the other changes are minor (as you'll see if you read this blog!).
- Changes to Power BI in the May 2019 Update
- Analysing the speed of Power BI reports
- Speeding up reports (this blog)
- Small changes for line chart and KPI labels
- Improvements to geolocation in ArcGIS Maps
- Features currently in preview for Power BI
Posted by Andy Brown on 20 May 2019
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Speeding up reports
Staying with the theme of analysing why reports are running more slowly, Microsoft have introduced two new ways to speed them up.
Stopping the automatic creation of unnecessary date tables
You can use the CALENDAR or CALENDARAUTO function in DAX to generate date tables automatically (Sam has recently blogged about this):
These functions analyse all of the tables in your model, and generate a date table accordingly.
However, if (like me) you'd much prefer to load your own date table, you can now tell Power BI to stop creating the internal date tables needed to support the above feature:
Go to File => Options, and untick this box to stop Power BI creating unnecessary internal date files for each table.
Except this new feature seems to be disabled by default anyway after you update Power BI (on my laptop, this box was already unticked).
It seems that Power BI was completing the execution of queries, even when their results weren't going to be needed. Microsoft have added the following optimisations:
|1||When you change filtering or slicer choices, any running query dependent on previous choices made is cancelled.|
|2||When you hide a visual, any query being run to populate/display the now-hidden visual is cancelled.|
|3||When you switch to a different report, any queries running for visuals on other pages are cancelled.|
|4||When you close a report, all of its running queries are cancelled.|
It's quite surprising that this didn't happen anyway, but reassuring to know that your computer is no longer chugging away to generate data which will never be used.
Note that all of the above is for Power BI Desktop only at the moment, although Microsoft intend to roll similar features out to Power BI Service soon.