Reply
KomalPawar
Frequent Visitor

Dataflows Parametrization

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?

1 ACCEPTED SOLUTION
miguel
Community Admin
Community Admin

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 

View solution in original post

1 REPLY 1
miguel
Community Admin
Community Admin

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 

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)