How to improve dashboard performance speed

Hi Anonymous,

Apart from the high volumes of data, the amount of visuals in the visual report also plays a role. You can check the loading time of each visual on the page by the means of a Performance Analyzer: https://docs.microsoft.com/nl-nl/power-bi/create-reports/desktop-performance-analyzer

1. Try to minimize the number of visuals in the dashboard as much as possible. Or you could try to optimize the visuals used, example by using a table visual to report a chunk of measures instead of using separate visuals for each measure. You could also split the top and bottom views into 2 different dashbaord pages and link them via navigation bookmarks.

2. Use of multiple filters on a visual-level also affects the rendering speed.

3.  Check the DAX measures. The DAX measures created could be computational-heavy causing the front-end to load slower. Optimize the DAX measures by using smarter functions.

For the data side of things, you could use a data modelling technique so that your data is queried and computed in an efficient way. You could refer to this link: https://hevodata.com/learn/data-model-in-power-query/

Hope this helped!