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

"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?

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

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

Same here, and my data source is Google Adwords, transferred using Google's transfer service, to Google's BigQuery. Hmmm.