Forum Discussion

Magellan57's avatar
Magellan57
Frequent Visitor
1 year ago
Solved

Power Automate - Run a query against against a dataset Timing Out Now

Hello,   I've posted on the Power Automate community board about this and waiting for a response but I figured I would post here to see if others on this board might have insight as well.   I cre...
  • v-echaithra's avatar
    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.


  • Magellan57's avatar
    Magellan57
    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.