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."
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.
Hi @Anonymous5,
How about trying to set retry policy?
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.