Forum Discussion
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.googleapis.com/v4/spreadsheets/**********fields=sheets/properties,namedRanges' (429): Too Many Requests.
I took to google support, and they suggest me to apply a delay after every request. It's possible?
Thanks a lot !
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
1 Reply
- danextianSuper 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