Skip to main content

Notifications

Power Automate - Using Connectors
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.
 
 
  • Anonymous5 Profile Picture
    Anonymous5 107 on at
    Re: Timeout for Transform Data using Power Query for SQL

    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.

  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Timeout for Transform Data using Power Query for SQL

    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.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics