Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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:

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!

Status: Investigating

Hi  @FeddeB ,

 

 429 Too Many Requests error. This error is typically due to hitting the Google Sheets API’s quota limits. 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @FeddeB ,

 

 429 Too Many Requests error. This error is typically due to hitting the Google Sheets API’s quota limits. 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

ryan0585
Advocate II

Sounds like Microsoft needs to limit how many calls they're sending to the Google API via Power BI. First the query evaluates, then it runs, yada yada yada.

 

I'd love an option to skip the evaluation step for things like this... too many queries for a simple refresh, and I feel like that's what's happening here.

 

I don't want to get on the phone with a Microsoft rep just to have someone tell me what I already know. I just want better Google Sheets integration.

FeddeB
Regular Visitor

@ryan0585 Indeed, this seems the case...

 

@v-xiaoyan-msft The API limits of Google should be sufficient if there wouldn't be so much calls from the connector. I basically only want to get some data from google sheets in a data flow.