Forum Discussion
Cannot display the datetime in a table using DirectQuery from Google BigQuery
Hi rgjiang ,
Please check whether the data type in Power BI is correct.
When your date column disappears, can you see the date in the Data view. If you can see the date column in the Data view, it means that the date column in the Report view is filtered out, possibly due to the existence of the relationship.
If possible, please provide me with specific screenshots.
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 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!