Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
72 | |
68 | |
41 | |
35 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |