The operation has timed out - Connection type Web

[Rflad]

Hi what is the time limit for the Connection type Web.

There are not any options to define this in the desktop client.

Is there an api/config file that contains these values locally on the comupter where the desktop client is installed?

[Greg_Deckler]

Unless something has changed, see the answer in this thread:

http://community.powerbi.com/t5/Desktop/sql-connection-time-out-from-power-bi-desktop/td-p/17307

There is an idea out there for it:

https://ideas.powerbi.com/forums/265200-power-bi?query=timeout

See the last one, but it does not have many votes.

[Rflad · Accepted solution]

Thanks for feedback, actually I believe I found the workaround/solution to it myself.

First step connect to a similar source and let it load.

Edit in advanced mode:
Add this part after the source part : [Timeout=#duration(0,0,5,0)] where (days,hours,min,sec) are the values.

The tip was found on technet:

https://social.technet.microsoft.com/Forums/en-US/d54165e2-04e4-44e3-888b-792dbe624660/power-query-h...

[Greg_Deckler]

M code to the rescue!