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.
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
Solved! Go to Solution.
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
They are tied together. When you download the Report PBIX it will contain all the data in the datamodel.
Hope this helps
Stuart
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.