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
Ayushman1997
Frequent Visitor

Bulk copy measures

Hi Everyone. I want to know if there is any way of copying bulk measures from one pbix to another pbix without using any external tool. "No External Tools"!!! The partial solution I found is:-

1. Zip both pbix. Extract both and open DataModelSchema in Notepadd++.

2. Search and Copy the measure from original pbix to the other. Then save in notepad++ and go back. Then place it 

3. The new pbix compress it zip to again, then save as pbit/pbic. Then open the new pbix. 

After step 3 it shows error as file is encrypted or corrupted and cannot be opened.

2 REPLIES 2

  1. Export Data Model:

    • Open the source .pbix file (the one with the measures you want to copy).
    • Go to "File" > "Options and settings" > "Options".
    • In the Options dialog box, navigate to "Current File" > "Data Load" > "Data Model".
    • Click on "Export Model" and save the .bim file (Power BI Data Model file).
  2. Import Data Model:

    • Open the target .pbix file (the one where you want to paste the measures).
    • Go to "File" > "Options and settings" > "Options".
    • In the Options dialog box, navigate to "Current File" > "Data Load" > "Data Model".
    • Click on "Import Model" and select the .bim file you exported in step 1.
  3. Review Measures:

    • Once imported, navigate to the "Model" view in Power BI Desktop to review the imported measures.
    • Ensure that the measures are present and appear as expected in the target .pbix file.
  4. Adjust as Needed:

    • If required, make any adjustments to the measures or data model in the target .pbix file.
  5. Save Changes:

    • Save the changes made to the target .pbix file.

Step 1 point 3. There's no data model inside data load

image.jpg

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.