Forum Discussion
Advocate IISemantic model cloud connection resets after deployment pipelin
Hi all,
I have one semantic model connected to a fabric lakehouse by a cloud connection in a dev envoironment and one model in test environment.
When deploying the model from dev workspace to test workspace the Cloud Connection resets to Default. Is there some setting that prevents it from resetting after each deployment?
Br
Adrian
Hello adnyk
Unfortunately, there is no direct method to prevent the cloud connection from resetting to default settings after deployment. While deployment rules can adjust parameters within the semantic model or its source, they do not support altering the connection type itself. Currently, Microsoft Fabric lacks a built-in feature to maintain cloud connection settings across deployments. The recommended approach is to update the cloud connection in the test environment after each deployment.If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank you!
6 Replies
- nilendraFabric
Super User
Hello adnyk
When deploying a semantic model across workspaces, Microsoft Fabric does default to resetting the cloud connection to "Default: Single Sign-On (SSO)" unless explicitly reconfigured. This behavior is linked to how deployment pipelines handle metadata updates but do not automatically retain environment-specific settings like cloud connections
Cloud connections are environment-specific and need to be reconfigured after deployment unless a mechanism such as deployment rules- Use deployment rules in your pipeline to dynamically update cloud connections during deployment.:
- Define parameters for cloud connections in your deployment pipeline.
- Map these parameters to appropriate values for each environment (e.g., Dev, Test, Prod).
- Example: Update server names or credentials based on the target environment.
If this is helpful please accept the solution and give kudos
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/create-rules?tabs=new-ui
adnykHi nilendraFabric and thank you for your reply.
As I understand it in deployment rules I can only change either parameters set inside the semantic model or the source of the model but not the connection used to access the source?- nilendraFabric
Deployment pipelines do not support changing the type of connection used to access the source. For example, if your semantic model uses a live connection or DirectQuery, you cannot switch it to another connectivity mode during deployment
- Use deployment rules in your pipeline to dynamically update cloud connections during deployment.:
v-karpurapudCommunity Support
Hello adnyk
Thank you for reaching out to Microsoft Fabric Community Forum.
Thank you nilendraFabric for your response.Could you please confirm if your query have been resolved the solution provided by nilendraFabric ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you
