Power BI Template App Tenant Migration

shape_not_found
shape_not_found

Occasionally we are asked how to download the .pbix for our reports for editing in Power BI Desktop, or how to move custom reports from one to another Power BI tenant. This blog will show you how to do both. However, the downloaded .pbix will not include the dataset. By design, it is not possible to download the dataset of a Power BI template app. To edit the .pbix in Power BI Desktop you must connect to a PowerStacks dataset in the Power BI service.

github mark2
Get the Script

Grab the script from the Github link above to get started. 

Create a Power BI Workspace

  1. In the Power BI service select Workspaces.
  2. Select New workspace.

This workspace will be used as a temporary location to store the reports that you want to download. It can be removed once you have downloaded the .pbix. 

Name the Workspace

  1. Enter a Name for the workspace.
  2. Select Apply.

Create a New Dataset

  1. In your new workspace select New.
  2. Select Dataset.

Define the Dataset

  1. Select Paste or manually enter data.

Create the Dataset

  1. On the Get data pane provide a Name for the dataset. I recommend using the same name as the dataset name in the workspace of the template app.
  2. Select Create a dataset only.

Ignore the Warning

  1. On the Enter data prompt select Create.

Copy the Script

  1. Open PowerShell ISE or your favorite code editor as Administrator.
  2. Copy the PowerShell script from the top of this page and paste it into the code editor.
  3. Run the script.
  4. When prompted to sign in use the same credentials that you use for Power BI.

Select Source Workspace

  1. At the Choose a source workspace prompt select the workspace containing the Power BI template app.
  2. Select OK.

Select Destination Workspace

  1. At the Choose a destination workspace select the workspace that you created following the steps above.
  2. Select OK.
Destination Workspace

Check for Errors

  1. Confirm no errors are in the script output.

Go to The Workspace

  1. In the Power BI service select Workspaces.
  2. Select the workspace that you created following the steps above.

Confirm Reports are Present

  1. In your workspace you should have a copy of each report from the workspace of the template app. If you do not see them refresh the browser page.

Download a .pbix

  1. Open a set of reports for the workspace.
  2. Select File.
  3. Select Download this file.

Download Report and Data

  1. At the What do you want to download prompt select A copy of your report and data (.pbix).
  2. Select Download.

Open the .pbix

  1. Open the downloaded .pbix in Power BI Desktop.
  2. Switch to Model view.
  3. Select the Vertical Ellipsis on the dataset.
  4. Select Delete from this model.

Install the Template App in New Tenant

Before proceeding ensure that you have installed the Power BI template app in the new tenant. 

If you simply wanted to modify the reports in Power BI desktop and upload them back to the template app in the tenant from which you downloaded them, you may do that also.

Add Template App Dataset

  1. This step can get tricky. If you are moving the reports to a new tenant, you might need to sign out of Power BI desktop and sign in to Power BI desktop with credentials from the new tenant. 
  2. In Power BI Desktop select Get data.
  3. Select Power BI datasets.

Connect to Online Dataset

  1. Select the dataset in the workspace that you'd like to upload the reports. This could be the same as the original source or in a new tenant. 
  2. Select Connect.

Optionally Edit Reports

  1. In Power BI Desktop switch to Report view. 
  2. You will notice that you have access to the online dataset and the report pages in the report. If you'd like to modify or creates pages do so now. 

Publish Report

  1. In Power BI Desktop select File.
  2. Select Publish.

Publish to Power BI

  1. Select Publish to Power BI.

Save Report

  1. If prompted, select Save.

Select Destination

  1. Select the Power BI template app workspace where you would like to publish the report. This should be the same workspace that you connected to in the "Connect to Online Dataset" step above.
  2. Select "Select".

Success!

You should see a Success dialog box.

Confirm Publish

In the Power BI service, you should now see your published report. If not, refresh the page in your browser.