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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors