Forum Discussion
Migrating a Semantic Model with multiple reports
I have a semantic model with multiple reports built off of it that I need to move from one tenant to another. How do I move all the reports without duplicating the semantic model a dozen times?
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!
7 Replies
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!
Thank you very much, I will try these out.
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.
To move your semantic model and reports from one tenant to another without duplicating the model:
- Export the PBIX file from the old tenant (or download the model from Power BI Service).
- Publish the PBIX to the new tenant's workspace to create the new dataset.
- Repoint the reports in the new tenant to the newly published dataset.
- Reconfigure data sources (if needed) and set up any necessary data gateways.
- Test the reports in the new tenant.
- Delete old reports and datasets from the original tenant, if desired.
This ensures you only have one version of the semantic model in the new tenant, preventing duplication.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKSHi jessicaheffler ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
You can use Deployment Pipelines in Power BI to move the semantic model and associated reports between tenants while avoiding duplication.- Create a deployment pipeline in your source tenant.Assign the workspace containing the semantic model and reports to the pipeline’s Development stage.
- Deploy the content to the Test stage in the pipeline. Ensure the dataset and reports are functioning correctly in this stage.
- Export the content (semantic model and reports) from the Test stage of the source tenant.Import it into a deployment pipeline in the target tenant by uploading it to the appropriate workspace.
- If the semantic model dataset resides in a different workspace in the target tenant, update the connections for the reports in the pipeline.
- Use the deployment pipeline in the target tenant to push the reports and dataset to the Production stage.
If this post was helpful, please consider marking Accepting it as a solution to guide other members in finding it more easily.
