too many columns when importing the data file

[needsomehelp]

Hello, I can't tell why, but when I try to import an xls file, power BI generates columns that should not be here. To make it short, my table only makes 49 columns in excel, but whe I import the file, power BI considers there are 78, which is really annoying. Does anyone know how to fix this?

It seems it only happens for 2 of the datasheets (the other 25 do not have this problem), so I guess there is something that prevents power BI from "knowing" where the table ends.

[amitchandak]

@needsomehelp , excel might have the empty column, Columns that have used but not properly deleted, That might be coming in.