Written by James Keane
When designing a report it’s important to think about the performance of the report including:
- The # of records
- The # of tables
- The # of joins
- The # of reports off the same dataset
- The # of calculations
- On Premises Data Gateway is up to date
Each of these areas will impact performance of the report and how long it takes to refresh a report and/or dataset.
There is also a tool in Power BI called the Power BI Performance Analyzer
You can access this by selecting View and Performance Analyzer in Power BI.
Any actions you take in the report are displayed and logged in the Performance Analyzer pane, in the order that the visual is loaded by Power BI.
This will analyze the time taken for dax to refresh, visuals to display and other (time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing) in ms.
This will help users to gain an insight into how their report functions and why a report or dataset may be functioning incorrectly.