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.
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?