Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DM_GWPipeline_Gateway_TimeoutError

I am getting lots of these errors on a dataset that used to work. Over the Easter weekend there was an error in one of my SQL based tables which caused duplication and broke my one to many join, this...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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,

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Allan, this seems to have worked in testing.