BigQuery Connector - Support DATE format

[Ezi_Ken]

Howdy,

Been testing out BigQuery with PowerBI and found that if we set a field to DATE and not TIMESTAMP. PowerBI still attempts a TIMESTAMP conversion which throws the follow error.

Now we can work around this with TIMESTAMP. But support for DATE would be nice, and thought I could provide feedback on the Beta Connector.

Cheers,

Ken

[v-jiascu-msft]

Hi @Ezi_Ken,

I have reported this issue to Product Team internally: CRI 52692290. I will post the updates in time.

Best Regards,

Dale

[Ezi_Ken]

Hi Dale @v-jiascu-msft,

Thanks for the fast feedback. More context, I am doing direct query straight to a BigQuery dataset (not a SQL query). Which it comes back fine. Issue is when I attempt to put the date field into a visual such as a matrix or table... Then it throws that error which I saw.

Cheers,

Ken

[v-jiascu-msft · Accepted solution]

Hi @Ezi_Ken,

I have gotten the response from the Product Team. The fix will be available in January 2018.

Best Regards,

Dale

[finer]

It appears this is still not fixed? Can anyone confirm and, if so, offer a workaround solution?

[v-jiascu-msft]

Hi @Ezi_Ken,

It seems that the limits are from the legacy SQL of BigQuery, which has limit support for Date type. Maybe you should use standard SQL in BigQuery. It works fine in my test.

You can see the details in my test.

Reference: https://cloud.google.com/bigquery/data-types

https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql

Best Regards,

Dale