is there a quicker way to duplicate Custom Measures?

[bwang2]

I have multiple PowerBI files, they share some data from the same data source, and have their own data and measures. I wish to combine these files. One major issue I have is to duplicate all the Custom Measures from one file to the combined files. Besides manually copy and pastes each Custom Measure one by one, is there a quicker way to accomplish this? 

[v-yifanw-msft]

Hi @bwang2 ,
Based on the information you provided, you could try saving one of the PBIX files as a template file (.pbit). Rename the template file to a zip file (.zip) and extract it. Use a text editor to open the data model schema file (.xml). Cut or copy the quantity values from the original table and paste them into a new table in the XML file. Save and close the XML file, then copy it back to the zip file. Rename the zip file back to the template file. Open the modified template file using Power BI. Verify that the metrics have been copied into the new table and repair any broken references.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bwang2 , Try the Suggestion from @_AAndrade  first. You can also use ALM toolkit to compare and merge files

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc

[bwang2]

Thanks, but ALM toolkit is not allowed by our administer, any other alternative to merge files?

[_AAndrade · Accepted solution]

Yes. Using tabular editor you can simply copy paste all measures from one file to the other file.