Power BI embedded slowness

[WilliamA]

Hi All,

I have several power BI reports embedded in my own web application. the issue is when you navigate to the link the power BI logo /loading spinning wheel can take 5-10 seconds to load the report which is far too long. A lot of people mention to improve your dax queries, number of visuals etc. However, I created one dashboard with serveral visuals, using large datasets and one dashboard with only 1 table and no visuals and both had the same loading speeds. (sometimes the larger report loaded quicker) 

Is there a way to decrease the time taken to call the power BI API's to render the reports?

[Poojara_D12]

Hi @WilliamA 

To reduce Power BI embedded report load times:

1. Optimize Embed Tokens: Use efficient token generation and caching.
2. Power BI Premium: Leverage dedicated capacity for better performance.
3. Minimize Latency: Host the app and Power BI in the same region; use a CDN.
4. Improve Embedding Code: Use asynchronous loading and the latest SDK.
5. Enable Caching: Use browser and Power BI caching effectively.
6. Streamline Reports: Limit initial visuals and simplify data models.
7. Preload Reports: Preload or lazy-load reports for quicker access.
8. Monitor Performance: Use tools like Power BI Performance Analyzer.
9. Optimize Gateways: Ensure the data gateway is well-configured and fast.

These steps improve loading and rendering speed.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[Anonymous · Accepted solution]

Hi @WilliamA ,

I recommend that you migrate your semantic model to Azure Analysis Services to improve query performance and load times. Azure Analysis Services provides powerful computing power and memory optimization, capable of handling large datasets and providing fast query response times.

Links:

What is Azure Analysis Services? | Microsoft Learn

Tutorial - Add a sample model- Azure Analysis Services | Microsoft Learn

Best regards,

Mengmeng Li