Forum Discussion
Excel Import into Query losing Column Headers
I have automated extracts from multiple different ERP system into Excel, to be subsequently imported into PBI. I have not had an issue other than on two (random) occasions related to one file. The ...
Luklaman , I am assuming you have defined step to convert the first row into the header in data transformation/edit query and it is not disturbed
amitchandak Yes. The file has been exported for an ERP system into Excel and imported into PBI for ~45 days without fault, and for no reason at all, PBI this time thinks there is no data in row one of the Excel file, puts 'null' in row one of the query.
I can only assume it is a bug in PBI, given the output to Excel is automated, it has worked without an issue for X days, the column headers still exist in the Excel file, it imports the first row from Excel into PBI, but cannot find any data and therefore puts 'null' into the fields.