I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content! For More 👉 ua-cam.com/users/EssentialExcel
Hi there, I have uploaded two excel files with a manual formula as shown on your video, and the tables appear on the query table. On the second step, Applied Steps>Source>Insert Step After->I entered the formula "Binary.Combine(Source[Content])", press enter. I get the following error: The input couldn't be recognized as a valid Excel document. Details: [Binary]. How can I fix this? Thanks for the help.
Hello 😀. I am currently working on a dedicated Power BI course playlist (link below) which will revisit this topic including practice files 😀 ua-cam.com/play/PLYy3v7WkxwZd1y6Y8_iN1-fJfDVHk8j1c.html&si=jUq3UEouYs0tkZf7
@essentialexcel I want to use this method, to combine two three files fetched using option of url paste in get data. I cant see the content column there, also the query is not working, can you suggest solution? Thanks in advance.
Sorry this wasn't helpful for you, however video was specific to combining CSV files. Although similar solution is available for XLS, this is not ideal as you also have to deal with multiple tabs... therefore CSV is the suggested solution.
Hello. Although solutions are available, I would strongly suggest first converting your XLS and contained tabs to CSV (possibly using Power Automate) then combining the CSV files as required. I could look to create this Power Automate tutorial if of interest?
Thanks. The files I have contain some cells filled with a colour that I would like to retain in the combined file (not via conditional formatting). Is there a way?
Still it would work. The order of columns do not matter till the time the Column Names are using the same spellings in each of the files. Hope it answers?
Has anyone had any problems with this method, I could not get it to work, yes it combined the binaries, but into one binary not a table, my usual method ; Table.TransformColumns( Source, {"Content", each Excel.Workbook(_) {[Name = "Table1"] }[Data] } ) Result in table to be expanded. Binary.Combine ( Source [Content] ) , just combined all binaries into a single binary ? so in the vid it worked as Table.Combine, any suggestions as to what i'm doing wrong?
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 ua-cam.com/users/EssentialExcel
Worked like magic! Successfully used this method to join 13 files with a total of 120k plus rows. Thank you!
Hi there, I have uploaded two excel files with a manual formula as shown on your video, and the tables appear on the query table. On the second step, Applied Steps>Source>Insert Step After->I entered the formula "Binary.Combine(Source[Content])", press enter. I get the following error: The input couldn't be recognized as a valid Excel document. Details: [Binary]. How can I fix this? Thanks for the help.
His source files are .CSV files. It fails with .XLS files
looks like it works only with csv, I tried csv and worked but with xlsx did not work,, do u know why?
Thanks for the great intro!
Thanks Archibald! 🙂
I need to do this but have some complex logic I'd like to match certain rows from file 1 with info from file 2 based on some criteria..
Thank you! It was super helpful - when appending files the regular what - by Folder - it does created a lot of unnecessary steps.
Do the files in the folder need to have a certain name ? Or can they be different names ? Or does name not matter? It will combine any file in there ?
excelent video exactly what i was looking for except did not work form me.. did not open a new table
= Binary.Combine(Source[Content]) is that right?
Didn't work for me too
Can we have the data file so we can practice. How are you maximizing your screen, are using magnifier of something else
Hello 😀. I am currently working on a dedicated Power BI course playlist (link below) which will revisit this topic including practice files 😀
ua-cam.com/play/PLYy3v7WkxwZd1y6Y8_iN1-fJfDVHk8j1c.html&si=jUq3UEouYs0tkZf7
Thank you!
Welcome Adam! 🙂
@essentialexcel I want to use this method, to combine two three files fetched using option of url paste in get data. I cant see the content column there, also the query is not working, can you suggest solution? Thanks in advance.
I have 5different file about a sales data how do I combine this files together, because from what you did the files have common columns
Any example files to practice??
Do these steps apply only if you have the same data per file?
How to add hyperlink as the sample task has to the final outcome of combined Excel
Frome where you took contain???
How to import along with formatting of source files.
please note, this does NOT work with xls files
Yeah not working
Sorry this wasn't helpful for you, however video was specific to combining CSV files. Although similar solution is available for XLS, this is not ideal as you also have to deal with multiple tabs... therefore CSV is the suggested solution.
Hi, how about combining multiple excel files with multiple sheets into one?
Hello. Although solutions are available, I would strongly suggest first converting your XLS and contained tabs to CSV (possibly using Power Automate) then combining the CSV files as required. I could look to create this Power Automate tutorial if of interest?
Yeah do that please
Why cant i fetch the DATA source by using = Folder . files
when I try to copy and paste the file path , I get this error message "Expression.SyntaxError: Token Comma expected." any idea how to sort this?
make sure your path is inbetween double quotes. Like this "your path". Could be the reason for your message!?
Thanks. The files I have contain some cells filled with a colour that I would like to retain in the combined file (not via conditional formatting). Is there a way?
No, it's just reading the data
what if the column orders are different in 2 files?
Still it would work. The order of columns do not matter till the time the Column Names are using the same spellings in each of the files. Hope it answers?
Thanx
Nice, but I believe too many change data type steps
I got an error when trying to combine
Hello 👋 Are you able to provide more detail on the order you experienced?
Good content but quality of video is not good
Has anyone had any problems with this method, I could not get it to work, yes it combined the binaries, but into one binary not a table, my usual method ;
Table.TransformColumns( Source,
{"Content", each Excel.Workbook(_) {[Name = "Table1"] }[Data] } )
Result in table to be expanded.
Binary.Combine ( Source [Content] ) , just combined all binaries into a single binary ? so in the vid it worked as Table.Combine, any suggestions as to what i'm doing wrong?