Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

v-lili6-msft
Community Support
‎01-05-2021 01:09 AM

Batch migration from one pbix file to another pbix

Scenario:   

Sometimes, we may have a raw pbix file, then assign it to two or more users to develop the reports. how do we combine these reports into one comprehensive report? You can have a try according to this article. 

 
 

 

Visuals 

Open two pbix files, selecte one or more visuals from one pbix file (you use Ctrl + left-click to multiple select) then copy it into another pbix file. 

Since these visual effects only have calculated metrics and calculated columns in report B, these visual effects in repot A will display errors.  We can fix it by migrating. 

1.png2.png

 

Calculated Measure /Column/Table 

Generally, Power BI built-in tabular editor is very useful as we can create Calculated Measure /Column/Table one by one manually, however, when you want to send a file of a table in a number of measurements to another file, you will find it very inconvenient. 

Now it could be easier if we enable the Tabular Editor in Power BI Desktop. Please refer to below blog for more information. 

 

  

Announcing public preview of external tools in Power BI Desktop 

  

Note: when you open Tabular Editor, Go to File → Preferences → under Features -> enable the below option which is highlighted in yellow. 

3.png

The operation steps are as follows: 

  

Step 1:  

Open the two PBI files. 

4.png

 

Step 2:  

Open Tabular Editor for these two pbix file 

5.png

 

Step 3:  

Click on one of the Measure in the B file, use Ctrl or Shift to select multiple, and then Ctrl+ C to copy 

 

6.png

 

Step 4:  

Switch to the B report’s Tabular Editor interface to paste and paste in.  

Selecte Table Sales and press Ctrl+V 

7.png

 

Step 5:  

Click Save or press Ctrl+S to save the changes.  

8.png

 

Now, go the two reports to see the result. 

9.png

 

Key points to note: 

  1. If the table names in the two files are different, the measurement value and the visual object used will report errors and need to be modified. 
  1. It is the same way for calculated column/Measure 

  

Relationship 

  

For relationship, you can also manage it in batches in the Tabular Editor. You can select one or more relations, and then make them active or inactive or deleted at once, and also copy them from one pbix file to another pbix file like Calculated Measure as above. 

10.png

 

 

 

Author: Lin Li 

Reviewer:  Kerry & Ula