topic Re: Bulk copy measures in Developer

Bulk copy measures

Ayushman1997 — Tue, 27 Feb 2024 19:47:24 GMT

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.

Re: Bulk copy measures

shravanreddy133 — Wed, 28 Feb 2024 02:25:04 GMT

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.

Re: Bulk copy measures

Ayushman1997 — Wed, 28 Feb 2024 03:43:16 GMT

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