"Cannot reference a SQL view in a Legacy SQL query" error with BigQuery data source in data layout[ Edited ]
February 2017 - last edited February 2017
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.