Embedded Service CPU Issue with Power Apps Cloud Flow Requests

Hi mikeyoungCO 

Key Points:

1. Issue:

   • Power BI Embedded (A1) CPU usage climbs continuously when paginated reports are triggered via Power Apps Cloud Flows.
   • CPU returns to baseline immediately after running the same reports from Power BI Web Service or a web app.

2. Behavior Observed:

   • Green spike: Report requests from Power BI Web Service quickly return CPU usage to baseline.
   • Pink spike: Report requests from a web app also stabilize CPU.
   • Requests from Power Apps Cloud Flows cause persistent CPU increase until the instance is restarted.

3. Possible Causes:

   • Inefficient handling of paginated reports by Power Apps Cloud Flows.
   • Potentially unoptimized API calls or connections between Power Apps and Power BI Embedded.
   • Resource contention or memory leaks in the Power BI Embedded instance.

4. Recommendations:

   • Investigate how Power Apps Cloud Flows execute API calls (e.g., frequency, caching, or parallel requests).
   • Optimize the Power Apps integration with Power BI by reviewing query and resource usage patterns.
   • Scale up the Power BI Embedded instance temporarily to test whether the issue persists.
   • Report the issue to Microsoft Support if the behavior is reproducible.

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
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS