cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andyparkerson Frequent Visitor
Frequent Visitor

Re: Query Timeout on update

Here's a reply to an old question:

 

https://docs.microsoft.com/en-us/powerquery-m/odbc-datasource

 

The second parameter is a record, so you want to include your command and connection timeouts inside the record, instead of multiple separate parameters.

 

Thus, you would have:

Source = Odbc.DataSource("dsn=PostgresSql64bit", [HierarchicalNavigation=true, ConnectionTimeout=#duration(0,0,5,0), CommandTimeout=#duration(0,0,5,0)])

The two durations don't have to match. The first is for the connection (how long it takes to initially connect), and the second is for the command (how long it takes to run the query).

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 21 members 812 guests
Please welcome our newest community members: