Forum Discussion
Unable to Refresh multiple (API) Web Queries that all use the same offline access token
- 2 years ago
Anonymous
Actually, I was able to find another solution,
I had to disable the parallel loading so that it would send one request at a time:
it seems our server gets busier and slower when processing all of these parallel requests simultaneously, which causes it to hit the 100-second Cloudflare timeout for some of them.
Hi salem_wafi
Try adding a "timeout" parameter in Web.Contents() function. Here is a similar case for your reference
Web.Contents - PowerQuery M | Microsoft Learn
Solved: Query Timeout on update - Microsoft Fabric Community
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- salem_wafi2 years agoFrequent Visitor
Thanks Anonymous
I tried that, but now it throws 524 because Cloudflare on the server timeout at 100 seconds, and that can't be changed.
Is there a workaround for that?- salem_wafi2 years agoFrequent Visitor
Anonymous
Actually, I was able to find another solution,
I had to disable the parallel loading so that it would send one request at a time:
it seems our server gets busier and slower when processing all of these parallel requests simultaneously, which causes it to hit the 100-second Cloudflare timeout for some of them.