5.2K members online now
Ask questions about Data Studio
Guide Me
favorite_border
Reply

"Cannot reference a SQL view in a Legacy SQL query" error with BigQuery data source in data layout

[ Edited ]
Level 5
# 1
Level 5

My data source is a Standard SQL view. After connecting to it successfully, the desired widget gives an error and cannot be populated or used:

There`s a query error.

Cannot reference a SQL view in a Legacy SQL query.

Error ID: d7d6c112

Do I really have to use only Legacy SQL views as data sources for Google Data Studio? Surely there's a way to tell GDS to use Standard SQL.