Applies to Product- Power Automate
What’s happening?
The flow is experiencing delays in updating data in Power BI, resulting in longer refresh times than previously observed.
Reason:
This is likely due to throttling from reaching the API limits on the Power BI connector. This can occur when the flow executes an excessive number of actions per day or when the service being connected to is running slowly.
Resolution:
- Review the flow run details to identify if it is getting stuck on a single step.
- Check for any 429 (Too Many Requests) errors in the flow, which indicate that the rate limit has been exceeded.
- Confirm if the flow is executing an excessive number of actions that exceed the daily action limits for the plan.
- Consider redesigning the flow to use fewer actions and less data. For example:
- Reduce the number of loop iterations in 'Do until' or 'For each item' loops.
- Utilize 'Filter query' and 'Top count' parameters to limit the number of items retrieved.
- If applicable, reduce the frequency of scheduled flows that run frequently.
- If the issue persists, consider upgrading to a Premium or Process license for better throughput and higher quotas. Please refer the documentation for more information: https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/flow-run-issues/troubleshoot-slow-running-flows