web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Timeout for Transform ...
Power Automate
Unanswered

Timeout for Transform Data using Power Query for SQL

(0) ShareShare
ReportReport
Posted on by 107

Hello All,

 

I have created a flow that utilizes the "Transform Data using Power Query" to an on-prem SQL database. For whatever reason, the loaded table is sluggish to produce within the query. I can see this within the flow editor and can take up to 4 minutes to appear for editing. 

 

This is causing some problems when I try to run the flow as the TimeOut limit is only 120 seconds. This causes the entire Flow to fail at this step with the following:

 

code:  BadRequest

message:  "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."

 
I can't explain why this particular query is so slow but I know if I had adequate time to let it run I could move on with the flow. I have done some research on how to overcome the 120 second limitation but I am having some trouble with the terminology for Synchronous and Asynchronous Pattern.
 
Asynchronous is switched on and I have tried to manipulate the "Timeout Duration" in the settings for this step of the flow using the recommended ISO format up to "PT5M" to increase to 5 minutes but this does not have any effect.
 
Inked2020-06-10_13-44-29_LI.jpg
 
I appreciate any help you can give. Let me know if any further information is required.
 
 
Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous5,

     

    How about trying to set retry policy?

    https://d365demystified.com/2020/04/19/setting-retry-policy-for-an-http-request-in-a-flow-power-automate/

    Annotation 2020-06-11 134215.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous5 Profile Picture
    107 on at

    Thanks for the reply.

     

    If I'm sure that an individual Power Query will take at least 5 minutes to produce a result I don't believe that any additional retries of the query will help here. If each retry starts the query from scratch, I will need the DURATION of the query to go beyond the default 120 second timeout.

     

    I made the adjustment to the retry policy as you recommended and it does not appear to have made any difference.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard