Forum Discussion
Solved
Error 429 "Too many requests" when refreshing a dataflow that has some google sheet files
HI community, I have been searching for information both on the internet and in the Power BI community without success. Due to company requirements, I must create a project management report...
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.
I´m going to try to combine some google sheet files into one. Hopefully it will reduce the requests.
James-PBI
Advocate I
Advocate II'm having the same issue. Did combining the Google sheets into one file help?
It did.
In one sheet within a google sheet? I experience the same, but this isn't really a solution, but I'll try to see if it can work for me... I have several google sheets for different Power BI reports and the refresh now fails more often than not..
- James-PBI
Please report back your findings! Would love to know if this is a possible workaround.