Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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 🙂
Solved! Go to Solution.
Hi @ronaldbalza2023 ,
You can use the Power Query editor to make the necessary transformations.
Select Get Data > Folder > Input your folder path
Then click Transform Data.
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:
If you did it right, you should only have your DimController files. Once correct, click the two down arrows to combine them together.
Hi @ronaldbalza2023 ,
You can use the Power Query editor to make the necessary transformations.
Select Get Data > Folder > Input your folder path
Then click Transform Data.
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:
If you did it right, you should only have your DimController files. Once correct, click the two down arrows to combine them together.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |