Power query cannot read first column

[Anonymous]

Hello. 

I have a report i get from our online data warehouse in a excel .xlsx file. 

This file always have null values in column "A". 

I place this file on a sharepoint which is connected to power Bi. 

But when i enable the binary content in power query to show me the report, column "A" is sometimes not showing. 

I have tried to save the sheet manually on my desktop before i move it to sharepoint, i have also tried to move it sharepoint without a save, but it has it own life as i sometimes read column "A" and sometimes don't. 

I dont get why this is happning as it is the same kind of file, from the same system we use every time. We cannot build a sustainable datasource if it can't read the file the same way every time. 

Please find power query and excel sampels below

[v-yuta-msft · Accepted solution]

@Anonymous ,

I could not reproduce this error but I have found a similar case below which may help you:

https://social.technet.microsoft.com/Forums/en-US/9d38f271-2cc6-4170-9a48-1e4f45f6f125/missed-column-from-xlsx-worksheet-on-import?forum=powerquery

Community Support Team _ Jimmy Tao

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