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!
Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi jessicaheffler 

To move your semantic model and reports from one tenant to another without duplicating the model:

  1. Export the PBIX file from the old tenant (or download the model from Power BI Service).
  2. Publish the PBIX to the new tenant's workspace to create the new dataset.
  3. Repoint the reports in the new tenant to the newly published dataset.
  4. Reconfigure data sources (if needed) and set up any necessary data gateways.
  5. Test the reports in the new tenant.
  6. 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=04iw9SYI2HN80HKS