Timeout of 100 seconds

[DianeDB]

I have 40 queries. When I "Refresh All" I often encounter "the web.page function didn't finish within timeout of 100 seconds."

I find, once it craps out, it cannot recover and waiting 100 seconds is too long. Each query normally takes 2-3 seconds, so I can tell quickly that it's failing.

Is there a registry setting or some other way to reduce the timeout value? 10-15 seconds would be plenty for me.

I hope we can solve this, I'm certain I'm not the only one.

 

[mole999]

what do you use to query ?

 

[DianeDB]

I am using Power Queries in Excel 2013

 

[shg]

See, perhaps https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query

 

[DianeDB]

I implemented this and it does not solve my issue.
I still get the 100 second timeout described above.
It must be a different timeout value/function.

Thank you and I'll try anything.

 

[mole999]

i don't use PQ but this seem likely > https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459