Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Post Patron
1 year ago
Solved

how to pass parameters to Dataflow in a Data Pipeline?

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 a...
data engineering
  • v-prasare's avatar
    v-prasare
    1 year ago

    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.
      1. Create a parameter in your Dataflow called InputDate.
      2. 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

v-prasare's avatar
v-prasare
Community Support
1 year ago

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.
    1. Create a parameter in your Dataflow called InputDate.
    2. 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