Forum Discussion

JeroenN's avatar
JeroenN
Advocate I
5 years ago
Solved

Timeout ODBC

Hi all!

 

Can anybody help me to increase the timeout on an ODBC connection?

The daily refresh of the data causes a timeout-error after two hours. 

 

I've tried to change this code:

 

 

let
    Bron = Odbc.DataSource("dsn=XXX099", [HierarchicalNavigation=true]),
    XXX099_Database = Bron{[Name="XXX099",Kind="Database"]}[Data],
    BI_Name_View = XXX099_Database{[Name="BI_Name",Kind="View"]}[Data]
in
    BI_Name_View

 

 

into: 

 

 

let
    Bron = Odbc.DataSource("dsn=XXX099",[CommandTimeout=#duration(0, 0, 15, 0)], [HierarchicalNavigation=true]),
    XXX099_Database = Bron{[Name="XXX099",Kind="Database"]}[Data],
    BI_Name_View = XXX099_Database{[Name="BI_Name",Kind="View"]}[Data]
in
    BI_Name_View

 

 

 

but this causes an error:

 

 

Expression.Error: 3 argumenten zijn doorgegeven aan een functie die tussen 1 en 2 verwacht.
Details:
    Pattern=
    Arguments=[List]

 

 

 

Can you hep me on this?

 

Thanks!

 

Jeroen