Forum Discussion

mariak's avatar
mariak
New Member
4 years ago

Uploaded workbook via Power Query doesn't match data in the original workbook

Hi, 

 

I have a workbook of data that, when I upload it through Power Query and look at the data in the Query Editor, the numbers in a given column do not match the numbers in the original workbook (when viewed simply in Excel, not the Query Editor.) Does anyone know why this is? There are no error messages or anything, and the column header names match perfectly. 

 

Thanks, 

Maria

 

 

Need Help

3 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    4 years ago

    What kind of an Excel file?  Please post examples of the data as you see it in Excel, and as you see it in Power Query.  The issue may have to do with Windows Regional Settings; setting of the data type in Power Query; or something else.

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    One possibility that comes to mind is that Power Query is showing you a cached preview of the data. Does the problem persist if you try clicking Refresh Preview or actually loading the data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mariak ,

     

    Are the data up to date? Or whether the data is all expanded.

     

     

    Best Regards,

    Stephen Tao

     

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