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

Graph error from a BigQuery View with JOIN statement query

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

I created a view in BigQuery (named: JoinExample) using a JOIN statement and works fine in BigQuery.

The query is this one:

SELECT
Ejercicios.Descripcion,
ActivoFijo.id,
ActivoFijo.ejercicio,
FROM
[angelic-tracer-xxx:intelisis_datastudio.ActivoFijo] AS ActivoFijo
JOIN
[angelic-tracer-xxx:intelisis_datastudio.Ejercicios] AS Ejercicios
ON
ActivoFijo.ejercicio = Ejercicios.Ejercicio

The results of the query looks like this:

Captura de pantalla 2017-06-29 a la(s) 15.50.23.png

When connecting Datastudio to this BigQuery view it creates automatically this dataset which looks fine:

Captura de pantalla 2017-06-29 a la(s) 15.49.00.png

Once I start using this dataset in a report I get an error:

Captura de pantalla 2017-06-29 a la(s) 15.51.52.png

 

In BigQuery I get this error:

Captura de pantalla 2017-06-29 a la(s) 16.03.25.png

What am I doing wrong?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author David L
June

Graph error from a BigQuery View with JOIN statement query

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Found how to solve it... I changed the query and added the expression "as field"... This is the new query in bigquery used to create the view.

SELECT
Ejercicios.Descripcion as Descripcion,
ActivoFijo.id as id,
ActivoFijo.ejercicio as ejercicio,
FROM
[angelic-tracer-166715:intelisis_datastudio.ActivoFijo] AS ActivoFijo
JOIN
[angelic-tracer-166715:intelisis_datastudio.Ejercicios] AS Ejercicios
ON
ActivoFijo.ejercicio = Ejercicios.Ejercicio

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author David L
June

Graph error from a BigQuery View with JOIN statement query

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Found how to solve it... I changed the query and added the expression "as field"... This is the new query in bigquery used to create the view.

SELECT
Ejercicios.Descripcion as Descripcion,
ActivoFijo.id as id,
ActivoFijo.ejercicio as ejercicio,
FROM
[angelic-tracer-166715:intelisis_datastudio.ActivoFijo] AS ActivoFijo
JOIN
[angelic-tracer-166715:intelisis_datastudio.Ejercicios] AS Ejercicios
ON
ActivoFijo.ejercicio = Ejercicios.Ejercicio

Graph error from a BigQuery View with JOIN statement query

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

@David L..Thanks.This helped me...