Optimizing Performance of Embedded Power BI Reports on Azure - Seeking Guidance

Poojitha Puligundla 5 Reputation points
2024-01-09T03:26:24.3733333+00:00

Hello Azure Community,

I hope this message finds you well. I'm currently working on a project where we have embedded Power BI reports into a React application hosted on Azure. While the reports load successfully, we are facing performance challenges, and I'm reaching out to this knowledgeable community for guidance and insights.

  • Azure Function App hosts the React application and is the backend for Power BI.
  • Power BI reports are embedded using the Power BI JavaScript API.
  • React application makes use of Azure services for various functionalities.

Observation:

When opening the Power BI reports directly in the Power BI service, the loading time is approximately 4 seconds. However, when embedded in our React application hosted on Azure, the loading time is consistently longer, often double the direct loading time.

Questions:

  1. Are there specific Azure configurations or optimizations that could enhance the performance of Power BI reports when embedded in a React application?
  2. How can we effectively leverage Azure services to minimize the loading time of Power BI reports within our React application?
  3. Are there best practices or considerations we should know when integrating Azure, Power BI, and React to ensure optimal performance?

Details:

  • Azure Function App configuration details.
  • Any specific Power BI service settings or optimizations we should explore?
  • Suggest optimizing the network connectivity between the React application, Azure, and Power BI.

I appreciate any insights, tips, or experiences you can share to help us improve the performance of our embedded Power BI reports.

Thank you in advance for your expertise!

Best regards,

Poojitha P.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,425 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MuthuKumaranMurugaachari-MSFT 22,406 Reputation points
    2024-01-11T15:36:48.9166667+00:00

    Poojitha Puligundla Thanks for posting your question in Microsoft Q&A. I assume you are already aware about Optimization guide for Power BI doc and its recommendations in general. From the description above, it looks like you are focusing on the call from Azure vs directly calling Rest API since it is taking twice the loading time.

    There are several factors that might affect performance such as network latency, capacity of the azure function (CPU/Memory) depending on the plan, react application code etc. I suggest start with Application Insights Integration as described in Monitor executions in Azure Functions doc which will help with performance counters, dependencies, network latency etc. If you observe slowness in the initial run, this could be related to cold start especially on the consumption plan (https://azure.microsoft.com/en-us/blog/understanding-serverless-cold-start/).

    Based on analyzing and monitoring logs, you can review scaling or optimize code for handling requests. It is also good to verify the react application performance in a different environment (or local/dev) and compare it with directly calling Rest API.

    I am not expert in PowerBI optimization and PowerBI is currently not supported in Microsoft Q&A forum. If you have any specific questions related to PowerBI, please post your question in https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1 and community experts can assist you further. I hope this helps and let me know if any questions.


    If you found the answer to your question helpful, please take a moment to mark it as Yes for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.