AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

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?