Forum Discussion
Error with automatic columns detection when combining excel files in folder
Thank you for your quick response, yes there is a "changed type" the problem is that PQ doesn't seem to detect the same thing with the first 7 files & the 3 others (there are 10 files in the folder) but they look exactly the same ... 1 header in B2 (merged cells), column headers starting at C4 and data starting at C5; and objectively it should be the same as this is the same extract from the same tool, only for different months.
I just tested and when I remove the file 8, 9 & 10 it works like a charm.
Steps of the "transform sample file" query :
- Source
- Navigation
- Removed columns
- Deleted first lines
- Headers promoted
- Changed type
EDIT : It seems that PowerBI doesn't like much when a merged cell begins before datas column ... I changed a bit the tool to align the report title with datas so all start in column B : report title, data headers, datas, and it works.
Thank you for your quick response, yes there is a "changed type" the problem is that PQ doesn't seem to detect the same thing with the first 7 files & the 3 others (there are 10 files in the folder) but they look exactly the same ... 1 header in B2 (merged cells), column headers starting at C4 and data starting at C5; and objectively it should be the same as this is the same extract from the same tool, only for different months.
I just tested and when I remove the file 8, 9 & 10 it works like a charm.
Steps of the "transform sample file" query :
- Source
- Navigation
- Removed columns
- Deleted first lines
- Headers promoted
- Changed type
EDIT : It seems that PowerBI doesn't like much when a merged cell begins before datas column ... I changed a bit the tool to align the report title with datas so all start in column B : report title, data headers, datas, and it works.