graph without period dimension - GAS/DataStudio

[sly felipa]

Through a connector I take the data from a table in BigQuery and paint it in DataStudio.

1 - problem

I use my community connector, I do a simple query and the start field (BigQuery - date type, GAS - YEAR_MONTH_DAY type, DataStudio - date type) is not displayed in a DataStudio chart.

In the graph it puts this error: "The query returned an error."

query: var BASE_SQL = 'SELECT * FROM `popeye-171509.bookings.tabla_test` WHERE id_owner = @ id_owner ';

The @id_owner parameter works correctly.

If I connect the same table with the BigQuery connector the start field appears correctly.

2 - problem

In the same condition as above.

The DataStudio connected to my community connector in any graph does not show the "dimension of the period".

The dataStudio connected to the BigQuery connector, in any chart does show "period dimension"

my community connector or my sql query have an error or is it a bug?

start - date type

BigQUERY                                         DataStudio

DataStudio

code

fields

.newDimension()

.setId('start')

.setName('start')

.setType(types.YEAR_MONTH_DAY);