Odd Behavior with Date Column

[bigfun]

When I view the table.. all the dates default to the same date and time.. (this just started to happen btw)

But when I open up into the table.. it all is fine

I deleted and reconnected the table, and it fixed it for just a couple days... I am perplexed to say the least

[VahidDM]

Can you please confirm the data type for that column in both images you shared are same?

Would that be because of Date/Time format of yoru data

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube 

[HotChilli]

Can you show us more details of each row please, especially a primary key value in each row? Can you find a row in Power Query and identify the same row in power bi table view?

How many rows are there in the table? Do they all show the same date?

Let's start with the hypothesis that it is not the same rows we are looking at. So let's prove that true or false to start with.

[bigfun]

There are over 4M rows in the table... And another thing to note.. is that it was working for a good while.. then it broke.. Also.. when I delete the table and then add it in again.. everything shows up fine and dandy

[Anonymous]

Hi @bigfun 

Thanks for the reply from HotChilli and VahidDM .

@bigfun , Could you please provide more information? For example what version of Power BI Desktop are you using? What is the data source you are using?

Here is the testing I performed, the version I used is:

I manually entered some data and it shows up fine.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.