Forum Discussion
Combine binaries returns null for columns with different header name
Hi LarsP
I am afraid this has to be done by hand. This is cited from official document: powerbi-desktop-combine-binaries
- Transformations were not considered for each individual file before the files were combined into a single table. As such, you often had to combine files, then filter out header values by filtering rows as part of the edit process.
- The Combine binaries transform only worked for text or CSV files, and didn't work on other supported file formats such as Excel workbooks, JSON files, and others.
BTW, combining Excel workbooks isn't support by now. If you'd like remove a row in the middle of the table, you could use "Remove alternate row".
Best Regards!
Dale
Microsoft EmployeeHi LarsP
What do you mean "Combine Binaries"? Just use "Append queries" in the Query Editor?
Best Regards!
Dale
Sorry for being unclear. Im trying to set up a solution where a collegue can connect to a folder where 3 excel files are located. The structure is always the same but the content is unique. My understanding was that that connection to more than one file is called Combine Binaries. If I need to manually remove the headers that is easier to do in excel.
Thanks for your explanation about append, it helped.
/LarsP
- v-jiascu-msft
Hi LarsP
I am afraid this has to be done by hand. This is cited from official document: powerbi-desktop-combine-binaries
- Transformations were not considered for each individual file before the files were combined into a single table. As such, you often had to combine files, then filter out header values by filtering rows as part of the edit process.
- The Combine binaries transform only worked for text or CSV files, and didn't work on other supported file formats such as Excel workbooks, JSON files, and others.
BTW, combining Excel workbooks isn't support by now. If you'd like remove a row in the middle of the table, you could use "Remove alternate row".
Best Regards!
Dale