Forum Discussion

Richmond_Dy's avatar
Richmond_Dy
Frequent Visitor
6 years ago

Data is different in Edit Query and Data View

Hi All, 


As the title states, there are differences between what I loaded in Edit Query vs what's appearing in Data View even though I hardly did anything to my data. 


Here's what it looks like on Edit Queries: https://imgur.com/a/VbCR0fn

 

That's what I want it to look like. 


After applying the queries, this is what appears: https://imgur.com/a/skRzb5K

 

I don't know why there are changes as the only thing I did was change the data type of one of the columns. 

Here's another example from the same file: https://imgur.com/a/y5ScQQt

 

Does anyone know why this is happening? Thanks

Need Help

7 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Richmond_Dy 

     

    Would you mind share me your dummy pbix? oddly that I never meet this before. It seems the column crossed after applying the power query. I'd like to check it in depth.

     

    • Richmond_Dy's avatar
      Richmond_Dy
      Frequent Visitor
      6 years ago
      Sure, how do I send the file? Also, if it matters, my pbix is linked to a google sheet.