cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ronaldbalza2023
Helper V
Helper V

Dynamically combine files from a folder

Hi everyone, I have files from a folder that adds a new file everyday. How can I dynamically combine these files based on the same name? Say DimController will be one table, DimMachine will be one table so and so....Thanks 🙂

ronaldbalza2023_0-1653784173504.png

 

1 ACCEPTED SOLUTION
hnguy71
Solution Sage
Solution Sage

Hi @ronaldbalza2023 ,

 

You can use the Power Query editor to make the necessary transformations. 

 

Select Get Data > Folder > Input your folder path

hnguy71_0-1653784749884.png

Then click Transform Data.

hnguy71_2-1653784998097.png

 

 

From here, for each of your tables you want, you can filter for the required files. For instance, if I wanted to filter and combine for DimController, the next applied step would be this:

hnguy71_5-1653785186868.png

 

If you did it right, you should only have your DimController files. Once correct, click the two down arrows to combine them together.


hnguy71_6-1653785250597.png

 

 



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

2 REPLIES 2
hnguy71
Solution Sage
Solution Sage

Hi @ronaldbalza2023 ,

 

You can use the Power Query editor to make the necessary transformations. 

 

Select Get Data > Folder > Input your folder path

hnguy71_0-1653784749884.png

Then click Transform Data.

hnguy71_2-1653784998097.png

 

 

From here, for each of your tables you want, you can filter for the required files. For instance, if I wanted to filter and combine for DimController, the next applied step would be this:

hnguy71_5-1653785186868.png

 

If you did it right, you should only have your DimController files. Once correct, click the two down arrows to combine them together.


hnguy71_6-1653785250597.png

 

 



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Thanks for taking the time on this @hnguy71 will give this a shot 🙂

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors