Forum Discussion

thinkindigo's avatar
thinkindigo
Regular Visitor
3 years ago

Power Query loads incorrect data when I upload excel file

I uploaded a report to Power Query from Excel.  In one of the columns, the numbers are different from the numbers in my original excel file that I uploaded.  I don't know how this could happen.  At first I thought it had something to do with my filters and added columns during the transform.  So, I tried uploading the report and I loaded the report to excel without any transform changes.  I checked for those numbers and again they were different from numbers in the original excel file.    I appreciate any help to resolve this.   I don't know if it could be a formatting issue because power query updates the data type.  The number could be listed as 27 in my original file and change to 1 when I load to excel.  I would like to know what I could check that may cause power query to change the numbers in my data.  Thanks.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi thinkindigo ,

     

    There could be several reasons why Power Query is loading incorrect data. Please kindly refer to

    Reference:

    Handling data source errors (Power Query) - Microsoft Support

     

                                                                                                                                                             

    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.