Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
arkiboys2
Helper IV
Helper IV

pass parameters to dataflow

Hello,

I have created a data factory pipeline in fabric. 

I have also created a dataflow with parameters on year, month and day

When I add the dataflow to the data factory pipeline, it does not see the parameters and so not sure how to call the dataflow to pass parameters.

any suggestions?

thank you

1 ACCEPTED SOLUTION
frithjof_v
Super User
Super User
5 REPLIES 5
jigneshpatel
Regular Visitor

The solution given in this post is about pipeline parameters. I am looking for dataflow parameter to be supplied when I add dataflow in my pipeline.

 

Also, in dataflow is there any way to have destination table name from parameter? as I do not see any script to update for destination.

 

Jignesh

frithjof_v
Super User
Super User

ramana97
New Member

Map pipeline parameters to Dataflow parameters in the activity settings. For example:

For the Dataflow parameter year, set it to @pipeline().parameters.year.

Do the same for month and day.

v-huijiey-msft
Community Support
Community Support

Hi @arkiboys2 ,

 

When importing data into the pipeline, you should be able to see information about the parameter, I think it may be that you are not harmonizing the parameter types inside the dataflow, please check:

vhuijieymsft_0-1729843409942.png

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

I see in your screen-shot you are referring to the pipeline parameter whereas I am referring to calling a dataflow activity from pipeline

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.