Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
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
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
hello,
i think you can try duplicating the table in transform data and then change the navigation and source
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
15 | |
7 | |
6 |