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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.