Forum Discussion
Schedule refresh error
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=sheets/properties,namedRanges[/ccon]' (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=sheets/properties,namedRanges[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: RLS Table.
Can anyone help me to understand the root cause for this.
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.
2 Replies
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.
Thank you! helped me to understand the root cause.
