The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredAsk the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.
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?
Solved! Go to 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):
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):