Status:
Investigating
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...
Google Sheets API Quotas:
- Requests per 100 seconds per user: 100
- Queries per 100 seconds per user: 60
- Writes per 100 seconds per user: 60
Change my mind:
Microsoft does not care about playing nice with google products.
If you want to lower the Google Sheets API’s requests you'll need to write and run your own script and save that data into a database.