Power Platform Community Forum Thread Details

Download data from planner flow sometimes runs for a very long time

Hello,

I've built a simple flow that extracts data from planner (plans, tasks, buckets, users etc.) and saves it to 3 different csv files which are then loaded into Power BI for reporting. Everything works great, except that sometimes the flow runs for a very long time (5h+) while standard flow duration is about 5-10 minutes.

I've noticed that the flow is more stable during the morning - can planner usage during business hours can have anything do with it?

The goal is to make the flow run once per hour so we always have the most fresh data possible in the PBI report.

Example of long flow run:

Example of standard flow run:

Run history for a last few days:

Thank you,

Tomas

Hi @TomasKrupa

Thank you for posting.

According to your description, you are encountering flow runs slowly issue from time to time. If any misunderstood, please kindly let me know.

Actually, there are several factors may affect flow behavior.

The service you are connecting to is running slowly.
The connector you are using is slowing your flow down as a service protection mechanism.
You might see a 429 (Too Many Requests) error in your flow with error text like like "Rate limit is exceeded. Try again in 27 seconds."
Your flow is executing an excessive number of actions per day, far in excess of the daily action limits for your plan.
Your flow is exceeding the data consumption allowance per day. This is the amount of data your flow consumes as a result of the input/output operations.
Your flow is exceeding a limit that is documented on the Power Automate limits and configuration page.

To alleviate the problem, we can try:

Redesigning your flow to use fewer actions and less data.
Purchasing a Per User or Per Flow license

https://support.microsoft.com/en-us/topic/troubleshooting-slow-running-flows-2a51dcd6-0b21-33da-5ce8-1e908b1540ef

If you still struggle with this issue, I recommend you can go to below website to request a remote troubleshooting support. We need capture processing log for further analysis.

https://flow.microsoft.com/en-us/support/

Hope the content above may help you.

Thanks

Anna

Quick Links

Leaderboard