I have a Google Data Studio report that depends on a BigQuery view, and this view queries a spreadsheet.
When loading the dashboard, I get the following in all my charts:
When I click in See details, I get the following:
BigQuery error: Invalid value: Error while reading table: test.test, error message: Failed to read the spreadsheet. Error code: RESOURCE_EXHAUSTED.
This error happens when I turn the report on for the first time, but then after some refreshes, the report works properly. Do you know how can I avoid this error?