Forum Discussion

jessicaheffler's avatar
jessicaheffler
Frequent Visitor
1 year ago
Solved

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?   
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    1 year ago

    jessicaheffler 

    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!
v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi 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.