Forum Discussion
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
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).
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.
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.
Adjust as Needed:
- If required, make any adjustments to the measures or data model in the target .pbix file.
Save Changes:
- Save the changes made to the target .pbix file.
Step 1 point 3. There's no data model inside data load
