Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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.
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
4 | |
4 | |
4 |