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.
Super UserThe 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-PBIAdvocate I
I'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..