Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Datetime error between Power Query and Power BI Desktop Visualization.

Hi.

 

I have a model connected to BigQuery.

 

One table has two TIMESTAMP columns that have dates on 01/01/1900. The hour is correct.

 

When I check the data on Power Query I have this result:

 

Screenshot 2025-12-16 163354.png

 

But, in the visualization I have this:

 

Screenshot 2025-12-16 163318.png

 

The worst part is that I tested filtering just one row on Power Query:

 

Screenshot 2025-12-16 163613.png

 

And worked in the visualization:

 

Screenshot 2025-12-16 163630.png

 

I did some research, and the result was that is an issue when Power BI Desktop receives data from Power Query and the way that both parts treat this type of data.

 

It is a big issue.

 

Best regards,

 


Emanuel Tavares

 




Status: New