One from many Sharepoint files does not recognize 1st column when importing?

[TungNguyen_19]

Hello everyone,

Today I faced to this very weird error. I have to combine all files from Sharepoints (of course they have same format/name_column/sheet_name) but after import one of those files has empty 1st column. You can see in below pictures:

This is other files, the column Feeder Vessel still appears data here:

But this files have null column (Even the title can not be recognized):

I have tried to import this single error file only (By Import Sharepoint List too but filter only this file) but now it can recognize this column. So it look like the error does not come from the Excel file on Sharepoint.

Does anyone face to this error? Please help me I have tried many ways this morning but it can not be fixed! Many thanks to you

[v-jingzhang]

Hi @TungNguyen_19 

As this only happens to one file, I don't think it is a Power Query issue. Please compare the column name of the first column "FINANCE SOB REPORT FROM..." with that in other files. Whether they are completely the same? Any prefix/suffix spaces or capitalized/lowercase differences will make them different column names and make data not appended into the same column. 

And drag the scroll bar to the far right to check whether there is a new column with a similar column name which only has data in rows of this file? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.