Forum Discussion
Query Timeout on update
jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.
Yes, it works.
you have to add a "null" in between
OData.Feed("http://some.url/service.svc/", null, [Timeout=#duration(0, 0, 5, 0)])
I'm having a similar problem (I think), but the solution described here doesn't seem to work.
Problem:
Attempted solution:
New problem:
Trying to reduce argument number to 2:
I have tested the ODBC connection in the Windows "ODBC Data Sources" app and it worked. Any ideas what I could be doing wrong / if there are any other workarounds?
Thanks!
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).
hi guys!
I kinda have a similar issue.
I am using the logic from Harry Gates to retrieve data from Essbase via XMLA.
http://harrygates-essbase-blog.blogspot.de/2016/09/power-query-how-to-connect-to-essbase.html
The timeout in my script is in the properties section, set to <Timeout>90000000</Timeout>
Despite this i am still getting the timeout error.
In Excel, with SmartView, i am able to retrieve the value in an acceptable time.
How can i solve this? Is there in PBI another timeout section somewhere???
Cheers.
Do you know how to make the Timeout for work this?
Source = Folder.Files("path/to/folder"),
