Optimize report loading time in Power BI Service

[Anonymous]

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

[v-easonf-msft · Accepted solution]

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

[Greg_Deckler]

@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.