Forum Discussion
merge two excel sheet
Dear all, I have a question concerning exploitation of an excel file.
In my PBI I take an specific excel sheet where I stored some data. For the new year I would like to create an other excel sheet in the same file but I would like in my PBI don't lost the otherone. I don't know how I can merge the datas from both files after some cleaning in order to get all datas (2022 and 2023). Attached you can see the sheet "Chantiers" which is the sheet for 2022 and I added "chantiers 2023" sheet with exactly the same structure.
Hi Anonymous ,
Here I will suggest you two workarounds.
1. You can load multiple tables you need from different sheets in same excel. Then use append to combine them.
For reference: Append queries
2. You can refer to below blog to follow the steps to combine different sheets from same excel.
For reference:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
FarhanAhmedCommunity Champion
If columns and their data type are same then you can use "Folder" as datasource then it will append the both files.
Hi Anonymous ,
Here I will suggest you two workarounds.
1. You can load multiple tables you need from different sheets in same excel. Then use append to combine them.
For reference: Append queries
2. You can refer to below blog to follow the steps to combine different sheets from same excel.
For reference:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.