Data Studio
4.1K members online now
4.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

System error - Google BigQuery

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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?