Forum Discussion
Solved
BigQuery Connector - Support DATE format
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 c...
Hi Ezi_Ken,
I have gotten the response from the Product Team. The fix will be available in January 2018.
Best Regards,
Dale
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