Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Magellan57
Frequent Visitor

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 created a Power Automate flow that includes the step "runs a query against dataset" to pull data from a report. I developed this Power Automate flow in June and ran it several times without any issues pulling data during development and troubleshooting. I scheduled it to run on 6/26, which was successful without any issues, but then I turned it off later on 6/26. Then on 7/23 I went to turn it back on and now it times out on the "runs a query against dataset" step. I've tried increasing the timeout time to 30 minutes without luck and still times out. I'm able to run the DAX code through DAX Query view on my desktop without any issues and returns data after 1 - 2 minutes. I reduced the report dataset size as I couldn't run the DAX before through my desktop as it was erroring out with "ran out of memory" error. Reducing the dataset size fixed this but it still won't pull data through the Power Automate flow when pointed to the report that I reduced the dataset on. Why would this be happening now and not before? Was there a change recently that Microsoft pushed out to the service that would impact this?

 

I confirmed I can pull data from the report through Power Automate when I use a simple DAX query to pull from the Date dimension for the current month.

 

The error is this......Action 'Run_a_query_against_a_dataset' failed: Http request failed: the server did not respond within the timeout limit. Please see logic app limits at https://aka.ms/logic-apps-limits-and-config#http-limits.

2 REPLIES 2
v-echaithra
Community Support
Community Support

Hi @Magellan57 ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

v-echaithra
Community Support
Community Support

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.


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.