Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I use the Google sheets connector in Power Query to get information from several Google Sheets into several datasets.
It worked great but somehow since a couple of months I am reaching the limit for some reason and get a 429 Too Many Requests error almost everytime the dataflow refreshes.
To lower the times the Google sheets API calls I created dataflows per google sheet and scheduled those all dataflows on different times, so they don't run at the same time, but still the refreshes fail more often than succeed. It seems that even getting data from one google sheet makes a lot of calls to the API.
I tried some suggestions I found:
I saw a similar issue in the Power Automate forum (https://powerusers.microsoft.com/t5/Using-Connectors/API-requests-limit-when-using-Google-Sheets-con...), I guess in Power Automate it is easier to use Exponential backoff, but still it seems like a problem.
Any help would be much appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.