Spredsheets - Too Many Requests

[cubo_bi]

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 !

[danextian · Accepted solution]

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