Dataflows Parametrization

[Anonymous]

Is there any way to parametrize dataflows in fabric?

I wanted to load tables from on prem SQL to lakehouse dynamically how i can do it with the help of dataflows?Is there any way to pass parameter to dataflows so i can build only one dataflow and load new tables by passing table name dynamically?

[miguel · Accepted solution]

You could use a metadata store, basically a table with the information that you need to drive the dynamic parameter approach, and then use those values against the logic that you have in your Dataflow. That is the recommended approcah today.

You can also suggest new approaches to parameterization by posting or voting for an idea in the Ideasl portal (link below):

https://aka.ms/FabricIdeas