System error - Google BigQuery
I get a few system error in one of my reports.
The data source is Bigquery and since there's quite a lot of data in the dataset, I'm using a custom query to only use a small part of the dataset.
When I edit the report and remove comparison data (Previous period) it's working again. Adding the comparison data back and it works.
This solution works as long as you don't change the date. My guess is that the query or data fetching is too heavy somehow and removing and adding the data comparison works because the parts of the data is cached.
Is there any way around this?
Is it the query that needs to be slimmer?
Too many different sources of data?