Forum Discussion
Cannot display the datetime in a table using DirectQuery from Google BigQuery
Hello Stephen,
thanks for your reply. Because I'm querying the data directly from Google BigQuery instead of importing the tables, I cannot display them in the data view.
Below, order_id and order_created_date_time are both columns from the same table.
However, once I drag the date slicer, the other visual can't be displayed anymore.
I think this behavior may be caused by DirectQuery because I didn't have this problem when I imported the data in the past. But because of the database size, I prefer to directly query the data.
Best
Hi rgjiang ,
Sorry for my late reply.
You can click See the details to view the cause of the error.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous,
I have written a new post which explains the problem in more detail Error in Visual: No matching signature for operator < for argument types: DATETIME, TIMESTAMP.
It would be of great help if you could take a look at it 🙂
Thanks and all the best!