topic Re: how to link parameters from the Pipeline into the Dataflow Gen2? in Pipelines

how to link parameters from the Pipeline into the Dataflow Gen2?

Anonymous — Wed, 18 Sep 2024 10:46:28 GMT

I have a parameter in a dataflow that is called "Source" which has a string value. This is used in a applied step in a query.

I want to be able to create a similar parameter in a Pipeline that can be linked into the "Source" parameter in the Dataflow and to be able to change the value in the Pipeline.

For instance, in the Dataflow I've got "Source" as 1 and in the Pipeline i want to change it to 2.

I can't see a parameter configuration is enabled in the Dataflow activity in the pipeline.

Re: how to link parameters from the Pipeline into the Dataflow Gen2?

charlyS — Wed, 18 Sep 2024 11:07:12 GMT

Hello Anonymous ,

Unfortunately, it's not possible at the moment to pass parameters from a pipeline to a dataflow using the dataflow activity. You can verify this information here: Microsoft Documentation.

As a workaround, it may be possible to configure your pipeline to update a configuration table or file. Then, you can set up your dataflow to retrieve this information, which can subsequently be used to parameterize your dataflow.