automatically Merge rows excel data in power BI

[Anonymous]

In each month I have a new excel data and I would like merge all datas by row (Now I have 10 files, January until october). Is it possible to auto merge  the excel datas every new files in the folder?

Furthermore, each file have same data structure, with 3 sheets and I would like to merge  just a specific sheet by row. After merge, I would like to remove rows duplicates.

[ray_aramburo]

You can by using the Folder connector and combining the files (preferrably have all the files you need stored in a single folder). On the UI you can specify which Sheet to select to merge the rows. After that, select all columns and click on Remove Duplicates.