Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power query cannot read first column

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

 
 
 

1 Reply