Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get Data Excel Doc Issue - Add'l "Row Number" Column Showing Up

I don't understand why when I bring a new Excel file from my local desktop into PowerBI, after the transformation, I receive the following below.   When I view the errors within the Editor, the first column says "Row Number".   This is not a column that exist in the existing Excel file.   I also see the 3rd column is listed as "Error".  Not all columns headings are  matching their content.

 

It should look like this:

Need Help

2 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    7 years ago

    Please share the Excel file, then I can have a Look.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    You said the new loaded Excel file lead to above error, what transformation did you make? Did you appent or merge the new table with the original one? Please click the "error" link to get detailed error message. If possible, please share your Excel file.

     

    Best regards,

    Yuliana Gu