Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
I have reported this issue to Product Team internally: CRI 52692290. I will post the updates in time.
Best Regards,
Dale
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
Hi @Ezi_Ken,
I have gotten the response from the Product Team. The fix will be available in January 2018.
Best Regards,
Dale
It appears this is still not fixed? Can anyone confirm and, if so, offer a workaround solution?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |