How to improve dashboard performance speed

[Anonymous]

Hi all,

I am working with a dataset of 40 million rows.

The top of the dashboard shows some aggregates/summary view of the data and the bottom of the dashboard contains a table that list the top-N data which allow users to download the data. 

I have tried improving the speed of the dashboard by removing unnecessary columns not required. However, the speed is still slow and i need all 40million rows, as users would be able to change the slicers to view the most granular level of data and download it. Is there any other ways that the dashboard speed can be improved?

[Anonymous]

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!

[v-yalanwu-msft]

Hi, @Anonymous ;

Please refer to the following 5 Quick Ways To Speed Up Your Power BI Dashboard：

1. Use Integers Whenever Possible

2. Remove Anything That Is Not Used

3. Stick To The Default Power Bi Widgets

4. Use Tabs

5. Use Top-N Rows In Tables

https://towardsdatascience.com/5-quick-ways-to-speed-up-your-power-bi-dashboard-41af7b46ea25

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanketBhagwat]

Hi @Anonymous .

Please refer to the link below;
Improve Power BI Performance by Optimizing DAX | MAQ Software.

Regards,

Sanket Bhagwat