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?   
  • tharunkumarRTK's avatar
    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!