migrate (deploy) semantic model from one work space to other workspace with partition data

[ShaikRafi]

Hi All,

We have one semantic model and 3 work space like dev,test and prod (we created this model to connect to excel and pviot data)

How we can move semantic model from one workspace to other work space with partition data also

[v-yilong-msft · Accepted solution]

Hi @ShaikRafi ,

Based on your problems, here are my answers.

If you want to move a report (including its semantic model) from one workspace to another, follow these steps.

If you have the .pbix file, great, If not, go to the report in Workspace A and choose File > Download to save a copy of the report to your desktop.

In Workspace B, select Browse and open the downloaded .pbix file. This action will publish the report and its dataset to Workspace B.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ShaikRafi]

@v-yilong-msft -May model have Incremnetal refresh ,then we unable to download

[lbendlin]

Connect via SSMS, harvest the definition scripts and recreate the meta data in the new location. Then fill the new partitions.

A simple alternative is to disable incremental refresh, download the PBIX and then re-enable incremental refresh.

[lbendlin]

Are your workspaces Premium?

Get started using deployment pipelines, the Fabric Application lifecycle management (ALM) tool - Mic...

[ShaikRafi]

yes we are using premium