Forum Discussion

Advocate I

10 years ago

Solved

The operation has timed out - Connection type Web

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

Rflad
10 years ago
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-http-timeout-setting?forum=powerquery

Community Champion

10 years ago

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.

Advocate I

10 years ago

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-http-timeout-setting?forum=powerquery

Greg_Deckler
Community Champion
10 years ago
M code to the rescue!