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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

transform each file the same way before merge

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

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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. 

21122104.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

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. 

21122104.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

watkinnc
Super User
Super User

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


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors