Forum Discussion
Apend excel files after merging some excel sheets
- 4 years ago
Hi rohit_singh ,
Thanks for responding, however this I know. This could not solve my issue.
Anyways, I figured out a way for getting my need done by connecting each table by folder then merging it in the combined table by making some unique columns.
Thanks and regards,
Rahul Kumar
Hi Rahul_SC ,
Please refer to this blog :
https://radacad.com/combine-multiple-or-all-sheets-from-an-excel-file-into-a-power-bi-solution-using-power-query-dynamically
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
- Rahul_SC4 years ago
Helper IV
Hi rohit_singh ,
Thanks for responding, however this I know. This could not solve my issue.
Anyways, I figured out a way for getting my need done by connecting each table by folder then merging it in the combined table by making some unique columns.
Thanks and regards,
Rahul Kumar