Forum Discussion
How to change sql database destination in DF2 in deployment pipeline?
Hi abpgupta,
As mentioned, currently, there's no built-in way to dynamically change the output destination during deployment, and it requires manually updating the destination in each environment. However, the product team is actively working on addressing this.
As noted in the Microsoft Fabric Roadmap, support for parameterizing the Dataflow Gen2 output destination is planned for public preview in Q3 2025. This should help streamline CI/CD deployments across workspaces once available.
For now, continuing with manual updates remains the approach until that feature is released.Thanks & Regards,
Prasanna Kumar
Hey abpgupta ,
In DF Gen2, the SQL Database destination mapping does not automatically change when you promote through a Deployment Pipeline, it stays linked to whatever connection you configured in Development. To point it to the respective stage database, you need to:
-
Create separate connections for each stage (Dev, Test, Prod) pointing to the correct Fabric SQL Database.
-
In your Deployment Pipeline settings, go to the Dataflow’s dataset parameter or connection mapping for the stage.
-
Edit the connection mapping so that the dataflow in Test points to the Test DB connection, and in Prod points to the Prod DB connection.
-
Publish again or trigger a refresh, now the dataflow will write to the correct database in that stage.
Currently, there’s no “auto-swap” for DF Gen2 destinations like with datasets. You have to set the mapping manually in each stage after deployment.
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
Thanks for response. Is there any plan to implement it in future to make it easy to manage connection without causing differences in deployment pipelines?
