cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yazo
New Member

Migrate Report to a new tenant

Good day, I would like to know is it possible to migrate a Workspace or Report to a new tenant and are there any risks or prerequisites for this?

 

I was told by a mate I need to download the pbix. file and publish to the new tenant

3 ACCEPTED SOLUTIONS
Burningsuit
Solution Sage
Solution Sage

Hi @yazo 

About the only method to migrate between tenants is to download and republish the PBIX files. This assumes you have the rights to download the PBIX from tenant1 and to publish reports into a Workspace on tenant2. You'll need to re-create any Dashboards you've created, as there's no download option for them.

If you've a very large list of Reports or Tenants to manage, you could automate this with PowerShell or the PowerBI REST API, but it might be very complex, see TenantManagement/README.md at main · PowerBiDevCamp/TenantManagement · GitHub

Hope this helps

Stuart

View solution in original post

Thank you so much, one question. In order to download the .pbix does the report need to be published through Power BI desktop or it will grey out the download option?

View solution in original post

Hi @yazo 

They are tied together. When you download the Report PBIX it will contain all the data in the datamodel.

Hope this helps

Stuart 

View solution in original post

6 REPLIES 6
yazo
New Member

Thanks for your feedback, do I need to download the report as well as the Dataset? Or are they tied together?

Hi @yazo 

They are tied together. When you download the Report PBIX it will contain all the data in the datamodel.

Hope this helps

Stuart 

I am able to see whoch Data source or on prem gateway the report is connected to, but there are others connected to a possible SQL instance or Analysis Service. Please explain if this is auto created or also has to be re connected etc. '

 

As you can see, in the top row the report is connect through the gateway. Not sure how the second one is configured

 

sd.PNG

Burningsuit
Solution Sage
Solution Sage

Hi @yazo 

About the only method to migrate between tenants is to download and republish the PBIX files. This assumes you have the rights to download the PBIX from tenant1 and to publish reports into a Workspace on tenant2. You'll need to re-create any Dashboards you've created, as there's no download option for them.

If you've a very large list of Reports or Tenants to manage, you could automate this with PowerShell or the PowerBI REST API, but it might be very complex, see TenantManagement/README.md at main · PowerBiDevCamp/TenantManagement · GitHub

Hope this helps

Stuart

Thank you so much, one question. In order to download the .pbix does the report need to be published through Power BI desktop or it will grey out the download option?

Hi @yazo 

There are several reasons PBIX download might be greyed out, see Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Docs

Basically it needs to be published through Power BI Desktop, or created in Service from a Dataset in the same workspace. But there are a few other things that will stop downloading..

  • This feature won't work with reports and the built-in downloadable samples originally created in the Power BI service, unless the report was created through the quick create experience.

  • If your administrator has turned off the ability to download data, this feature won't be visible in the Power BI service.

  • Datasets with incremental refresh can't be downloaded to a PBIX file.

  • Datasets enabled for large models and the reports created from these datasets can't be downloaded to a PBIX file.

  • Downloading a PBIX file after deployment isn't supported as part of the deployment pipeline (ALM).

  • Usage metric reports can't be downloaded to a PBIX file.

  • Datasets modified by using the XMLA endpoint can't be downloaded to a PBIX file.

  • If you create a Power BI report based on a dataset in one workspace and publish to a different workspace, you and your users won't be able to download it. The download feature is not supported in this scenario.

Hope this helps

Stuart

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors