Enable to pass variables from pipelines as parameters into a Dataflow Gen2

[#1]

Enable to modify the mashup document of a Dataflow Gen2 by passing a variable from a pipeline before an execution of the Dataflow

[Marcus_Wegener1]

That would be great, because then I could use the pipelines to control and execute dataflows and, for example, execute the same dataflow on different sources.

[JVolk1]

Ability to make a data source use a parameter - it is possible in Powerbi data load but not in data factory. This would enable promotion of data sources from Dev to production without altering code.

[suketu_dudhat]

This would be a great feature to have to increase the value of switching our workflows to Dataflow Gen 2 from TE3 and XMLA!

[Peter_Blake]

Definitely require this feature to make DFG2's effective for ETLing a large number of rows from an app via of REST calls that require an advancing row offset - i.e. many calls of the same DFG2 in which only the offset changes.

[bassfabricdemo1]

Would like this feature to be available soon as need to have the flexibility to run Data Flow from Pipeline with parameters

[zuora-integrati]

Looking forward to this feature

[akadri]

Looking forward to this feature

[Scott_Powell1]

I'm trying to move large tables from on-prem SQL server to Fabric. Until the data gateways or mirroring improvements go live, splitting the work into many dataflows each touching a different "slice" of data and appending into a Lakehouse is the only viable solution. But this is currently extremely painful, because:

1. You can't simple "save as" a dataflow as a copy. Which means you have to set up many copies of the same dataflow manually, manually map them to the destination tables, etc.
2. You can't change the parameters in the dataflows via a pipeline, which means you can't have a single job that you can reuse for multiple slices in parallel

I also agree with the comments about allowing the data sources and data destinations to be controllable via parameters. In my case, if I'm running 10 copies of a dataflow each dealing with a slice of data, I might want to spread them across different gateway clusters so I don't bog any of them down.

Thanks,

Scott

[Richard_Rann]

I would think this is a basic function. How can you not pass parameters into a Gen2 Dataflow, ie to dynamically build the SQL?

I'd expect this in January

[chenghan_wang]

Need this very much!!!!!