Parametrize Dataflow Gen2 destination

[michal_mlaka]

Please enable Dataflow Gen2 destination parametrization.

We would like to parametrize the path/table in destination Lakehouse.

[dan_alstrup1]

This is a huge issue for us. We are rolling out dataflow gen 2 to over 40 workspaces. Each workflow has a SQL source with 41 tables, which we have those connections parameterized. We are loading these into a lakehouse. We use the dataflow Gen 2 template to deploy these and we just have to set the parameters and the source is taken care of. The destination is a different story. We have to go into all 41 tables and set the destination to the workspace and lakehouse that we need for this workspace. Please add this feature soon!!!!

[BEJCC]

Dear This issue has been reported back in 2023. I understand a recent development allows to pass data destination as a pipeline parameter, ideally it is a deployment parameter. We can see Dataflows everywhere on Fabric slides, yet they are seemingly impossible to deploy via the Workspace Deployment Pipelines. Only works with ADO and Git. This is ridiculous. I've already switched my whole environment to notebooks. I still want to leverage dataflows though, for the correct use case. I don't understand how this is not a known issue or development. And why this idea is not sprawling with votes.

[BHouston1]

This is sorely needed and should be feasible to implement now that public parameters and CI/CD in Dataflows gen2 are becoming GA as of Q2 2025. Please include functionality for parameterized DF destinations so that we can have finally an end-to-end automated Deployment Pipelines solution for DF.

[miguel]

This is currently available and we have some guides to help you with how to use parameters or variables to dynamically pass values to use in your data destination:

CI/CD and ALM solution architectures for Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

[GertjanIdema]

I don't consider this issue COMPLETED. The only is a workaround editing the dataflow source using git. That's not what I would call a solution. Please reopen this issue.

[miguel]

@GertjanIdema do feel free to open a new idea that better describes the functionality that you'd like to see added.

From a functional standpoint, we added support for parameterization and for such evaluations to happen and be fully supported by the Dataflow engine via public parameters and/or Fabric variable libraries.