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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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