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.

(429): Too Many Requests when connecting to google sheet

I am working on a project where I need to use the data from a google sheet.

I am not able to import the data because of the 429 error: too many requests.

Via another reporting tool, I am able connected to that specific sheet.


(429): Too Many Requests
Details:
DataSourceKind=GoogleSheets
....

ranges=Overview%20pagina!A1:AH73170&fields=sheets/data/rowData/values/effectiveFormat/numberFormat,sheets/data/rowData/values/effectiveValue

Status: Investigating

Hi  @jtaelman 

The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. Please try to combine some google sheet files into one .

 

Best Regards,
Community Support Team _ Ailsa Tao

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

Hi  @jtaelman 

The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. Please try to combine some google sheet files into one .

 

Best Regards,
Community Support Team _ Ailsa Tao

jtaelman
Regular Visitor

@v-yetao1-msft 

 

There is only one sheet.

I have some conditional selection boxes in that sheet (referring to selection options in a second sheet) to limit the user's input, but also for user friendliness.

 

There is no other sheet involved.

 

A far less advanced reporting tool only takes the selected values in a column, which is how I assume it should work.