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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.