Forum Discussion

WilliamA's avatar
WilliamA
Helper I
1 year ago
Solved

Power BI embedded slowness

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • Poojara_D12's avatar
    Poojara_D12
    Super User
    1 year ago

    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