Forum Discussion
Error 429 "Too many requests" when refreshing a dataflow that has some google sheet files
The solution provided in a microsoft ticket was "Reduce the load/data to avoid too many request error" and to contact Google support. To be honest that reply is not helpfulYou may not like it but that reply is accurate. The 429 red card is handed to you by Google, not by Power Automate.
Any idea how to avoid error 429 "Too many requests"Refactor your workflow to reduce the number of requests against that source system.
Advocate IVThere seems to be something else at play here other than reducing the number of requests.
I have a single tab Google Sheet with roughly 40 rows and 10 columns. VERY small data load. I have it connected to my Power BI desktop via import. When I attempt to right-click on the data source and refresh it manually by itself (no other refreshes or requests but this), it CONSTANTLY returns the "429 too many requests" error. Sometimes it takes me 3 or 4 attempts before it will refresh the source.
Advocate IThis happens to me too. By any chance, are there often other collaborators in this spreadsheet making changes or adding data? Or do you have any Google App Scripts running for this sheet? In my case, I think these other factors are contributing to the Google quota limit.
- JustSayJoe
Hi James.
There are no collaborators. I'm the only person with access to the Sheet. There are no Google App Scripts running either.