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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Resident Rockstar
Resident Rockstar

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

7 REPLIES 7
patilp
Regular Visitor

If the reports and data sets are in different workspaces, we are not able to upload them to the new tenant. The upload gives an error (error 400). We tried splitting the report and model into two different pbix files (using a script available in github) but that didnt help either. We also tried replacing the conenction file (by chnaging pbix to zip, opening the archive, and replacing the connection file with the one on the new tenant etc.). Any ideas how to migrate in such a scenario where reports and datasets are in different worksapces ? Thanks in advance.

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
Resident Rockstar
Resident Rockstar

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors