cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Oleh_Karavskyi
Frequent Visitor

Auto refresh/ connect to google sheets doesn't work, always getting Error: (429): Too Many Requests

Hi.
Could you pls help, want to connect to google sheets and at least one time per day update my bi dasbords app/ workspase

Always when I try update manyally or set schedule update always getting such error:

Processing errorWeb.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/*******?fields=sheets/properties,namedRanges' (429): Too Many Requests

 

I don't need to update data every minute, just want that bi managed to take updated data from google sheets one/two times per day

2 REPLIES 2
v-yetao1-msft
Community Support
Community Support

Hi @Oleh_Karavskyi 

The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. How did you connect to Google and get data? Web connector or REST API ?

 

Best Regard

Community Support Team _ Ailsa Tao

HI!@,

Thank you a lot for your soonest response!
I'm connecting to google sheets using = GoogleSheets.Contents(
with Organisational privacy level

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors