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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Vegas95
Regular Visitor

Help me please

Hi everyone,

 

I need to do the same analysis that I made on a file to another file that has the same source, but different number of culumns and rows.

I have a question for you: Can I import a new dataset and mantein the same changes that I made on the first file? 

 

thank you so much for helping me.

1 ACCEPTED SOLUTION
AilleryO
Memorable Member
Memorable Member

Hi,

The transformations you made with Power Query are coded in M language and they are using the name of the columns.

Knowing that, you'll understand that the number of columns is not so much a subject, but the name of them is. So you need to have the same columns names, to copy paste one code to another project.

Or you'll have to modify the M code to adapt it to your new project 😉

 

Hope it helps

View solution in original post

2 REPLIES 2
AilleryO
Memorable Member
Memorable Member

Hi,

The transformations you made with Power Query are coded in M language and they are using the name of the columns.

Knowing that, you'll understand that the number of columns is not so much a subject, but the name of them is. So you need to have the same columns names, to copy paste one code to another project.

Or you'll have to modify the M code to adapt it to your new project 😉

 

Hope it helps

Anonymous
Not applicable

hello,
i think you can try duplicating the table in transform data and then change the navigation and source

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.