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 ...
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
Hello, how do you check if workbook sheets are stored as common data table format? I've the same issue and can't seem to find this info on WWW.