Forum Discussion
Power Automate - Run a query against against a dataset Timing Out Now
- 1 year ago
Hi Magellan57 ,
Thank you for reaching out to Microsoft Community.Power Automate’s “Run a query against a dataset” action has a timeout limit, regardless of any manual timeout extension configured within the flow settings. This limitation often leads to failures when running complex or long-running DAX queries especially after recent backend service updates that may have further tightened retry behavior.
If your query runs successfully in tools like Power BI Desktop or DAX Studio but fails in Power Automate, it is likely due to this timeout constraint rather than an issue with the query itself.Split long queries into smaller parts
Offload execution using Azure Functions or Logic Apps
Replace the default action with a custom connector using the Power BI REST API and try again.
Best Regards,
Chaithra E. - 1 year ago
This confirms what another Micrsoft Support Engineer mentioned during a support call. There's a default timeout configuration thats set in the background for 2 minutes.
Hi Magellan57 ,
Thank you for reaching out to Microsoft Community.
Power Automate’s “Run a query against a dataset” action has a timeout limit, regardless of any manual timeout extension configured within the flow settings. This limitation often leads to failures when running complex or long-running DAX queries especially after recent backend service updates that may have further tightened retry behavior.
If your query runs successfully in tools like Power BI Desktop or DAX Studio but fails in Power Automate, it is likely due to this timeout constraint rather than an issue with the query itself.
Split long queries into smaller parts
Offload execution using Azure Functions or Logic Apps
Replace the default action with a custom connector using the Power BI REST API and try again.
Best Regards,
Chaithra E.
This confirms what another Micrsoft Support Engineer mentioned during a support call. There's a default timeout configuration thats set in the background for 2 minutes.