Changing Data Source in custom Semantic Model

[aayushiharalal]

Hello Everyone,

I have created a Semantic Model using the "New Semantic Model" option available in the warehouse within my Dev Workspace.

After successfully deploying the Semantic Model to my Production Workspace using the deployment pipeline, I now need to point the model to the production workspace warehouse. However, it seems there is no option to update the source connection of my Semantic Model to the new workspace.

Can anyone guide me on how to redirect my Semantic Model to the Production Workspace warehouse?

Thank you!
@rajendraongole1 , @Kedar_Pande , @Ritaf1983 

[amitchandak · Accepted solution]

@aayushiharalal , Open in Tabular editor 3. You will see the connection string. You can modify that with details of production (SQL End point and Lakehouse/warehouse name)

I usually create a custom semantic model with one table and then migrate it using ALM toolkit

https://youtu.be/uJb5ajRqBKg

Both Above option requires XMLA endpoint to enabled at tenant level and read/write permission at capacity level

If we are able to deployment pipeline, we will get option to change settings