Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

automatically Merge rows excel data in power BI

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...
Show and Tell
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

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.