Cannot display the datetime in a table using DirectQuery from Google BigQuery

[rgjiang]

Hello everyone,

I have a column in date/time format m/d/yyyy h:nn:ss AM/PM that can be visualized through the date slicer for dragging it in between the desired dates. However, when I move it, the other visuals using columns from the same table cannot be displayed anymore. Moreover, when I try to visualize this date/time column as a table or any other type of visual other than the date slicer , it can't be displayed either.

I really do not understand this behavior. Any help would be greatly appreciated!

[Anonymous]

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.

[rgjiang]

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

[Anonymous]

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.

[rgjiang]

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!

[amitchandak]

@rgjiang , Datetime should display in the format selected/default in column tools (you can see when you click on column) in a table and matrix visual. In case it shows date hierarchy, right click on the column in the visualization pane and chooses date