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.
I appreciate any help you can give. Let me know if any further information is required.
