The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |