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. 

 

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. 

The operation steps are as follows: 

  

Step 1:  

Open the two PBI files. 

 

Step 2:  

Open Tabular Editor for these two pbix file 

 

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 

 

 

Step 4:  

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

Selecte Table Sales and press Ctrl+V 

 

Step 5:  

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

 

Now, go the two reports to see the result. 

 

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. 

 

 

 

Author: Lin Li 

Reviewer:  Kerry & Ula