Forum Discussion

Ezi_Ken's avatar
Ezi_Ken
Frequent Visitor
8 years ago
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...
Dashboards
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Ezi_Ken,

     

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

     

    Best Regards,

    Dale

Ezi_Ken's avatar
Ezi_Ken
Frequent Visitor
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Ezi_Ken,

     

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

     

    Best Regards,

    Dale

    • finer's avatar
      finer
      New Member
      2 years ago

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