- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
copy measure ALM Toolkit
Hi guys,
I need to copy a lot of measures from a report to another. How can i do it?
I've tried by ALM Toolkit but I don't know to do it.
Have you an idea?
Thank you 😊
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You will need an external tool Tabular Editor for this. If you already don’t have it, then please install it first.
You can visit the Tabular Editor website to download the latest installer.
You will then have 2 running instances of Power BI Desktop on your PC as you need to open both the pbix files at the same time. Make sure you are clear which file is which. Just rename your files for better understanding.
Here I have 2 files one is ‘Employee_details with Measures’ and another is ‘Employee_details without Measures’.
Launch Tabular Editor for both PBIX files
Go to each file, one at a time, and launch Tabular Editor. Do it carefully, one at a time, ensuring you understand which model belongs to which PBIX file.
Copy the Measures
If you can’t see measures in the source file, make sure they are not hidden.
In Tabular Editor, from the View menu, select Measures. We can see that the measures are visible in the ‘Employee_details with Measures’ file shown in the image below(left side).
In our case, all the measures exist in the _Measure Table.
Below are the steps to copy measures from one file to another:
- Select all measures from the list you want to copy.
- Copy the measures. Press Ctrl+C.
- Switch to the second instance of Tabular editor(one that’s not having measures)
- Select the destination table to store the measures.
- Paste the measures. Press Ctrl+V.
Click save on Tabular Editor in the destination workbook.
After saving the destination model, you will be able to see all the measures in the destination file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You will need an external tool Tabular Editor for this. If you already don’t have it, then please install it first.
You can visit the Tabular Editor website to download the latest installer.
You will then have 2 running instances of Power BI Desktop on your PC as you need to open both the pbix files at the same time. Make sure you are clear which file is which. Just rename your files for better understanding.
Here I have 2 files one is ‘Employee_details with Measures’ and another is ‘Employee_details without Measures’.
Launch Tabular Editor for both PBIX files
Go to each file, one at a time, and launch Tabular Editor. Do it carefully, one at a time, ensuring you understand which model belongs to which PBIX file.
Copy the Measures
If you can’t see measures in the source file, make sure they are not hidden.
In Tabular Editor, from the View menu, select Measures. We can see that the measures are visible in the ‘Employee_details with Measures’ file shown in the image below(left side).
In our case, all the measures exist in the _Measure Table.
Below are the steps to copy measures from one file to another:
- Select all measures from the list you want to copy.
- Copy the measures. Press Ctrl+C.
- Switch to the second instance of Tabular editor(one that’s not having measures)
- Select the destination table to store the measures.
- Paste the measures. Press Ctrl+V.
Click save on Tabular Editor in the destination workbook.
After saving the destination model, you will be able to see all the measures in the destination file.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-02-2023 08:08 AM | |||
09-25-2020 02:33 AM | |||
02-04-2024 05:02 PM | |||
04-01-2024 12:47 PM | |||
08-01-2024 08:29 AM |
User | Count |
---|---|
10 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
3 | |
2 | |
2 | |
2 |