Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello, let's suppose I have many files in the folder (daily added).
All these csv have the same structure.
So I need to apply the same power query transformation to each file before I can marge them: filter, delete columns, pivot, fill down, rename, unpivot...
Could you please tell me how to proceed whrite the M code - to apply these transformations to each file separatly before combining them.
Than you
Solved! Go to Solution.
Hi @Anonymous
If you use SharePoint folder connector or Folder connector to connect to multiple files, when you combine files, you will select a sample file like below. After combining, the structure of queries will be changed like below. You just have to edit the Transform Sample File query. Then all changes will be applied to the combined data in Query1.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
If you use SharePoint folder connector or Folder connector to connect to multiple files, when you combine files, you will select a sample file like below. After combining, the structure of queries will be changed like below. You just have to edit the Transform Sample File query. Then all changes will be applied to the combined data in Query1.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
You can just do your transforms on the transform sample file and then they'll apply to all of your tables before you combine them.
--Nate
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
70 | |
63 | |
40 | |
28 | |
15 |