Forum Discussion
DM_GWPipeline_Gateway_TimeoutError
Hi, Anonymous
You may try the following code in advanced editor. It appears correct.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
I'd like to suggest you increase the CommandTimeout and the ConnectionTimeout parameters to two hours to see if it works. The default value for ComandTimeout is ten minutes and the default value for ConnectionTimeout is driver-dependent. You may go to Power Query to modify them. For further information, please refer the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-alq-msft , thanks for your response, I wasn't aware the CommandTimeout default was 10mins. I have been able to update this to 2 hours using the source, however it's not immediately obvious how to also change the ConnectionTimeout.
I have tried setting this in the M Query as below, but I receive the error seen below the opening to the M Query:
let
Source = Sql.Databases("conncectionstring", [CommandTimeout=#duration(0, 2, 0, 0)] , [ConnectionTimeout=#duration(0, 2, 0, 0)]),
database = Source{[Name="database"]}[Data],
"Expression.Error: 3 arguments were passed to a function which expects between 1 and 2.
Details:
Pattern=
Arguments=[List]"
Are you able to give me a bit of guidance on how I can set this value?
Thanks,
Hi, Anonymous
You may try the following code in advanced editor. It appears correct.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Allan, this seems to have worked in testing.