Forum Discussion

nleuck's avatar
nleuck
Post Patron
6 years ago

Power BI displays data different than source data?

Hello Everyone,

 

I could use some help to understand what Power BI is doing to my data. My data souce is SQL Server and I'm in Directy Query mode. Below is a picutre of my data from SQL Server:

 

Below is a picture of my data in Power BI:

 

The rows are sorted the same and should match, but rows 2, 4, and 9 do not match with the source data. Can anyone please explain what's going on?

 

Thanks!

Need Help

2 Replies

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi nleuck ,

    Change the Direct Query mode to Import mode to see if the result is the same; perhaps you can check if the data format of the Access_StartTime2 column and the Access_EndTime2 column are the same.

    Best Regards,

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

    • nleuck's avatar
      nleuck
      Post Patron
      6 years ago

      v-joesh-msft 

       

      The report needs to be in Direct Query mode, but I did try using Import and got the same results. I don't understand why the data would be different in the first place.

       

      Thanks,