Forum Discussion
Optimize report loading time in Power BI Service
Hi Guys,
I would like to seek for suggestion to optimize the report loading time in Power BI service.
In my report, I have charts as below and data source is using import.
- 5 Slicer
- 2 Bullet Chart
- 1 Table
- 17 Card
- 11 KPI indicator
Currently my report loading time is around 17 seconds.
May I know is there any way to minimize the report loading time, perhaps can optimize to below 10 seconds?
Thanks in advance.
Regards,
Yit Chuen
Hi , Anonymous
Most of the performance issues are caused by the data model. Star Schema is recommended.
The dax function you use will also affect your report performance.You can consider using Power BI Desktop Performance Analyzer to help you analyse and optimize the report .
If still slow, you can upgrade your system. Good CPU and Memory will better help in calculating measures and in-memory storage.
Related document and video for your reference.
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
https://www.youtube.com/watch?v=B-h3Pohtn1Y
https://blog.bismart.com/en/why-is-my-power-bi-report-so-slow
Best Regards,
Community Support Team _ Eason
2 Replies
- Greg_Deckler
Community Champion
Anonymous - That is a HUGE topic. I have some tips and tricks in these articles:
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-2/ba-p/976813
Not sure how much help there is to share that is specific. The blog articles above were developed when the individual could share their PBIX file and I could really dig in and troubleshoot things. But, your measure formulas are probably going to have a big impact on how fast the report renders.
- v-easonf-msft
Community Support
Hi , Anonymous
Most of the performance issues are caused by the data model. Star Schema is recommended.
The dax function you use will also affect your report performance.You can consider using Power BI Desktop Performance Analyzer to help you analyse and optimize the report .
If still slow, you can upgrade your system. Good CPU and Memory will better help in calculating measures and in-memory storage.
Related document and video for your reference.
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
https://www.youtube.com/watch?v=B-h3Pohtn1Y
https://blog.bismart.com/en/why-is-my-power-bi-report-so-slow
Best Regards,
Community Support Team _ Eason
