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.
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.
Thanks for the workaround.
[timeout=#duration(0,0,30,0)]))
Can you share these parameters?
Would like to see this as a setting in the query builder.
>>[timeout=#duration(0,0,30,0)]))
This is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.
So, this setting represents a timeout of 30 minutes.
Can you advise if its valid to go over for a given unit?
For instance 0,0,0,90 instead of 0,0,1,30
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!
I have this issue in excel where I am referencing a URL in a table. How would this solution be applied as per below?
= Excel.Workbook(Web.Contents(
let
Source = Excel.CurrentWorkbook(),
SpmReports = Source{[Name="SpmReports"]}[Content],
#"Report URL" = SpmReports{6}[Report URL]
in
#"Report URL"
), null, true)Source = Folder.Files("path/to/data"),Do you know how to apply the timeout on this above M Code? I am trying to read from a local folder which is larger than 1GB and I am on the PPU liscense and workspace.
https://docs.microsoft.com/en-us/powerquery-m/folder-files
This function also takes options as a record, so I'd try the same way as the ODBC connector.
Namely,
Source = Folder.Files("Path/to/folder", [timeout=#duration(0,0,30,0)]),The options that the function Folder.Files takes are not spelled out, so you'll have to try a few of them to see if one of them works.
andyparkerson , thank you for the reply. So this one you are suggesting, I tried it and PowerBi won't recognize it. What other options can I try? Is there a place where I can find their list?
