Function Odbc.DataSource error with Timeout settings.

[Galat198]

I want to set a max timeout for ODBC connection to 15 minutes.
I add another parameter like:
Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true], [Timeout=#duration(0, 0, 15, 0)])

But I get an error that I have more parameters than allowed. Why is there such an error? After all, it is allowed to set up to 5 parameters in this function Odbc.DataSource.

[lbendlin · Accepted solution]

correct, "Timeout" is not a valid option.

Odbc.DataSource - PowerQuery M | Microsoft Docs

[lbendlin · Accepted solution]

correct, "Timeout" is not a valid option.

Odbc.DataSource - PowerQuery M | Microsoft Docs

[lbendlin]

Too many square brackets.

Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, Timeout=#duration(0, 0, 15, 0)])

[Galat198]

Hi @lbendlin ,
This way I also get an error:

[v-kelly-msft · Accepted solution]

Hi  @Galat198 ,

Use "ConnectionTimeout" instead:

Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, ConnectionTimeout=#duration(0, 0, 15, 0)])

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!