Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Galat198
Helper IV
Helper IV

Function Odbc.DataSource error with Timeout settings.

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)])

Galat198_1-1626936168895.png

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.

 

Galat198_2-1626936287782.png

 

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

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!

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

correct, "Timeout" is not a valid option.

 

Odbc.DataSource - PowerQuery M | Microsoft Docs

lbendlin
Super User
Super User

Too many square brackets.

 

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

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

Galat198_0-1627077167817.png

 

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors