Forum Discussion
cubo_bi
2 years agoNew Member
Spredsheets - Too Many Requests
Hi! I have a report that connected to google spreedsheets via api. When I try to save the report in PowerBi Desktop, it's returns: Web.Contents could not get the content of 'https://sheets.goo...
- 2 years ago
Hi cubo_bi
Web.BrowserContents has a WaitFor option.
https://learn.microsoft.com/en-us/powerquery-m/web-browsercontents
You may also try the approach in this post which uses Function.InvokeAfter
https://community.fabric.microsoft.com/t5/Desktop/Delay-a-web-query-before-calling-it/m-p/916700
danextian
2 years agoSuper User
Hi cubo_bi
Web.BrowserContents has a WaitFor option.
https://learn.microsoft.com/en-us/powerquery-m/web-browsercontents
You may also try the approach in this post which uses Function.InvokeAfter
https://community.fabric.microsoft.com/t5/Desktop/Delay-a-web-query-before-calling-it/m-p/916700