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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.