Forum Discussion
Excel Import into Query losing Column Headers
HI Luklaman,
AFAIK, power bi does not support advanced format headers(e.g. multiple level header or fields that combine multiple row/columns) Please double-check on your workbook sheets to confirm they are stored as a common data table format.
Regards,
Xiaoxin Sheng
Hi Anonymous
The file has been exported from SAP for ~45 days and imported into PBI. The export and import/publishing are automated, and therefore the file format should not change. This is the second time this one file has failed on import for the same issue.
The first time it failed I removed all formatting from the first row in the Excel file, but that did not resolve the issue. There are no merged cells, all the column headers are in row 1. I have managed to resolve the issue manually by copying the data into a new workbook, saving the file over the first one. But I shouldn't need to manually intervene in the process!
This is a strange one......and I can only think Power BI has a bug (how can it fail after X days when the input file format is unchanged?).
HI Luklaman,
What methods did you use to import your records? Get data with excel connector or using import feature to import excel workbook?
Can you please share some dummy data with the minimum structure to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng