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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Find articles, guides, information and community news

Most Recent
TedPattison
Employee
Employee

Learn how to use the Tabular Editor to perform advanced data modeling techniques not available when working with Power BI Desktop. Michael Kovolsky will introduce the Best Practice Analyzer and discuss how to use this powerful tool to scan your Power BI data model to find areas for improvement.

Read more...

vinaypugalia
Resolver I
Resolver I

Have you ever questioned if it is feasible to move all of the measures from one Power BI PBIX file to any other PBIX file?

Imagine you've got 2 PBIX files with the same models, i.e all tables used in the measures have the same data structure. If someday you are in this position then there will be a lot of measures to move from one file to another. Copying and pasting measures one by one can be a test from hell. It is a wolf in sheep’s clothing. It takes your efforts as well as your time.

 

So how to do it at one go? 

 

Here is the solution for it!

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.

1.png

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.

 

2.png

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.

 

3.png

After saving the destination model, you will be able to see all the measures in the destination file.

Happy Reporting!

FarhanAhmed
Community Champion
Community Champion

Customers ask you to show total values in a bar-chart for all years along with each year individually.

 

FarhanAhmed_0-1601358870005.png

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.