Datetime error between Power Query and Power BI Desktop Visualization.

[EmanuelTavares]

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:

But, in the visualization I have this:

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

And worked in the visualization:

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