Forum Discussion

bigfun's avatar
bigfun
Helper I
1 year ago

Odd Behavior with Date Column

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 reconnecte...
Need Help
HotChilli's avatar
HotChilli
Community Champion
1 year ago

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's avatar
bigfun
Helper I
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

    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.