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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Memorable Member
Memorable Member

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
Memorable Member
Memorable Member

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.