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

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

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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.

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

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

hi Karen,

  I am facing same issue. do you get an answer or solution to this?