https://community.fabric.microsoft.com/t5/Dataflow/Dataflows-Parametrization/m-p/3701480#M1980 <P>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.</P> <P>&nbsp;</P> <P>You can also suggest new approaches to parameterization by posting or voting for an idea in the Ideasl portal (link below):</P> <P><A href="https://aka.ms/FabricIdeas" target="_blank">https://aka.ms/FabricIdeas</A>&nbsp;</P> Thu, 15 Feb 2024 14:09:07 GMT miguel 2024-02-15T14:09:07Z https://community.fabric.microsoft.com/t5/Dataflow/Dataflows-Parametrization/m-p/3701237#M1975 <P>Is there any way to parametrize dataflows in fabric?</P><P>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?</P> Thu, 15 Feb 2024 12:31:28 GMT https://community.fabric.microsoft.com/t5/Dataflow/Dataflows-Parametrization/m-p/3701237#M1975 Anonymous 2024-02-15T12:31:28Z https://community.fabric.microsoft.com/t5/Dataflow/Dataflows-Parametrization/m-p/3701480#M1980 <P>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.</P> <P>&nbsp;</P> <P>You can also suggest new approaches to parameterization by posting or voting for an idea in the Ideasl portal (link below):</P> <P><A href="https://aka.ms/FabricIdeas" target="_blank">https://aka.ms/FabricIdeas</A>&nbsp;</P> Thu, 15 Feb 2024 14:09:07 GMT https://community.fabric.microsoft.com/t5/Dataflow/Dataflows-Parametrization/m-p/3701480#M1980 miguel 2024-02-15T14:09:07Z