- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Too many requests when using Google Sheets connector
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:
- Using Table.buffer -> no succes
- Exponential backoff in Power Query ->Was not able to get that to work properly (https://developers.google.com/sheets/api/limits#quota)
- Increasing the quota limits -> If I login to https://console.cloud.google.com/apis/dashboard with the user I also use in the google sheet connector I don't see any usage and I think it is not possible to increase it.
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.
-
allyklee
on: Remove / Copy Visual issue - July 2025 Desktop Iss...
- stipa on: Error "[403.12–403.30] The name 'Lakehouse.Content...
-
klinejordan
on: URL is not filtering on field parameter
- MaAl on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
- zsombor on: Matrix Visual doesn't work with Field Parameters ...
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- New 8,049
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,247 -
Data Modeling
4,135 -
Dashboards
4,116 -
Gateways
2,116 -
Report Server
2,116 -
APIS and Embedding
1,966 -
Custom Visuals
1,790 -
Content Packs
525 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1