Forum Discussion
Migrating a Semantic Model with multiple reports
There are multiple ways to perform this activity
Approach 1: Manual
1. Download all your reports into local machine. It will download all reports along with the copy of same semantic model.
2. Open one report from desktop and publish it to other tenant.
3. From second report onwards, open each report and delete all the data (tables, parameters, disabled queries in power query etc) and then connect to the semantic model that you have publihsed to your new tenant.
4. Then publish the report.
With this you will be able to publish the reports with out creating multiple semantic models.
Appraoch 2: semi automated
1. Connect your existing workspace to GIT.
2. Sync the artifacts to a git repository.
3. Clone the repository to your local machine.
4. Push it to a different ADO reposiotry or github repository.
5 Open your new tenant and connect your power bi workspace to the new repository and sync the repo.
6. This should move all your reports and sematic model to new tenant.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
I am trying the first approach. Everything goes well until, I try to publish the second report. I am getting a message saying no workspaces were found in the Power BI service.
Hi jessicaheffler ,
First, create the reports in Power BI Desktop using Tenant 1 credentials. While creating the reports, set the Sensitivity label to General. Save the report, and then publish it to the Power BI Service in Tenant 1 worspace.
Verify that the account you're using has access to workspaces in the target tenant.Check if you're a member or have the appropriate role (Admin, Contributor) for the workspace where you want to publish. You can check this by logging into the Power BI Service in a browser and navigating to Workspaces.
Then, open each report in the Power BI Service and download it as a .pbix file. Repeat this step for all the reports.
Open Power BI Desktop using Tenant 2 credentials, import the reports that were downloaded locally, and then publish them to the Power BI Service in Tenant 2 workspace.
Later we can delete the files in the local system not to repeat duplication.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Thank you, uploading from within the second tenant was the trick