Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ronaldbalza2023
Continued Contributor
Continued Contributor

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
Super User
Super User

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
Super User
Super User

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.