Forum Discussion
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
Hi JeroenN ,
are you using a Pro or Premium license?
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Data refreshes must complete in less than 2 hours on shared capacity. If your datasets require longer refresh operations, consider moving the dataset onto a Premium capacity. On Premium, the maximum refresh duration is 5 hours.
1 Reply
- mwegenerMost Valuable Professional
Hi JeroenN ,
are you using a Pro or Premium license?
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Data refreshes must complete in less than 2 hours on shared capacity. If your datasets require longer refresh operations, consider moving the dataset onto a Premium capacity. On Premium, the maximum refresh duration is 5 hours.