Schedule refresh error

[EWS_PBIDev]

I am encountering the following error sometimes during schedule refresh. This report is schedule refresh two times a day 7 AM & 7PM. I published this report a week ago. Google sheets are acting as source files along with SQL tables. The issue is that 7PM refresh failed 2 times while 7 AM refresh has been successful till now.

[ValidateMarkupTags][ccon]DataSource.Error: Web.Contents failed to get contents from '[ccon]https://sheets.googleapis.com/v4/spreadsheets/15ElTLM0D1WskaDUlFUM9IMLuO5JoFuBa0YVDs-Rovbs?fields=sh...]' (429): [ccon]Too Many Requests[/ccon]. DataSourceKind = [ccon]GoogleSheets[/ccon]. DataSourcePath = [ccon]https://docs.google.com/spreadsheets/d/15ElTLM0D1WskaDUlFUM9IMLuO5JoFuBa0YVDs-Rovbs/edit#gid=0[/ccon]. Url = [ccon]https://sheets.googleapis.com/v4/spreadsheets/15ElTLM0D1WskaDUlFUM9IMLuO5JoFuBa0YVDs-Rovbs?fields=sh...]. [/ccon]. The exception was raised by the IDbCommand interface. Table: RLS Table.

Can anyone help me to understand the root cause for this.

[EWS_PBIDev]

Thank you! helped me to understand the root cause.

[lbendlin · Accepted solution]

429 - you have overloaded the data source with too many requests, and are being punished for it.

Figure out what caused this and try to be less resource consuming.