topic how to pass parameters to Dataflow in a Data Pipeline? in Data Engineering

how to pass parameters to Dataflow in a Data Pipeline?

tan_thiamhuat — Sun, 10 Aug 2025 03:17:06 GMT

I need to pass a range of dates (generated by a Notebook) to a Dataflow which is in a ForEach loop, as seen below:

a) In the Notebook, it creates a array of dates:

with its StartDate and EndDate specified as Parameters:

b) I need to pass those of each date ['2025-08-01','2025-08-02', '2025-08-03'] to the Dataflow in the ForEach loop. In the ForEach, Settings->Items, I have below:

c) In the Dataflow, I have the InputDate which is hardcoded:

How do I pass the InputDate as a Parameter to the Dataflow?

Thanks.

Re: how to pass parameters to Dataflow in a Data Pipeline?

v-prasare — Mon, 11 Aug 2025 09:00:44 GMT

Hi tan_thiamhuat,

please follow below steps to pass dates dynamically:

Make your notebook return a JSON array of dates like: ["2025-08-01","2025-08-02","2025-08-03"]
In the ForEach Items box, read that output: @json(activity('Notebook_GenerateDates').output.result.exitValue)
Pass into Dataflow – Inside the ForEach, open the Dataflow activity → Parameters tab.

Create a parameter in your Dataflow called InputDate.
Map it to the loop’s current value: @item()

Use in Dataflow – In Power Query, replace your hard-coded line: InputDate = "2025-08-01" with the parameter: InputDate = Text.From(InputDate)

Thanks,

Prashanth Are

MS Fabric community support

Re: how to pass parameters to Dataflow in a Data Pipeline?

v-prasare — Tue, 19 Aug 2025 10:03:09 GMT

Hi tan_thiamhuat,

We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thanks,

Prashanth

MS fabric community support