Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Don-Bot
Resolver I
Resolver I

Dynamic connection to sources in Fabric

Hi, I'm looking at converting my data pipelines over to Fabric and I was wondering if there is an ability to use parameters like we can in Azure Data Factory and Synapse in Fabric Data Pipelines?

I found this link from a year ago stating it wasn't supported yet:  Dynamic Connections

 

But I haven't found anything since.  

Below is a sample of what i want to parameterize.  

DonBot_0-1736173494721.png

 

This is the connection used in the initial Lookup activity.

 

DonBot_0-1736173573530.png

 

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

@Don-Bot 

Unfortunately , that level of parameterization of connection details is yet not available in fabirc as of today.

Fabric lacks dyanmic aspects of connections details and Key vault linkage as of today.

 

The only thing that can be parameterized is the connection name within the source/sink but not the connection aspect details like server name etc




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

4 REPLIES 4
NandanHegde
Super User
Super User

@Don-Bot 

Unfortunately , that level of parameterization of connection details is yet not available in fabirc as of today.

Fabric lacks dyanmic aspects of connections details and Key vault linkage as of today.

 

The only thing that can be parameterized is the connection name within the source/sink but not the connection aspect details like server name etc




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
v-nuoc-msft
Community Support
Community Support

Hi @Don-Bot 

 

You can now use parameters in Fabric Data Pipelines, just like in Azure Data Factory and Synapse.

 

This feature allows you to create dynamic and flexible data pipelines by passing external values ​​into pipeline resources. You can use parameters alone or as part of an expression.

 

For example, you can parameterize connection details such as server name, database name, and authentication type.

 

The following links are the latest content on parameterization:

 

Parameters - Microsoft Fabric | Microsoft Learn

 

I hope this helps. If you have any further questions about this issue, please let me know.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for the reply @v-nuoc-msft ,

You stated that it works just like in Synapse and Data Factory Pipelines but I see a difference when I try to work with parameters in a connection.  

In Synapse you see what i have above.  Where I can set the parameters for things like ServerName, Database Name and what not for the Linked Service Properties.  

For Fabric it looks like I'm restricted to the connection.  Which may not be a deal breaker but I wanted to confirm that I can't pass more than that through.  

And is the ability to use dynamic content for connections limited to the lakehouse and other fabric offerings?  And not a connection to something like SQL Server?  Which I believe was

DonBot_0-1736259135985.png

 




Hi @Don-Bot 

 

Thanks to NandanHegde for helping explain. Please forgive me for any mistakes in expression.

 

You can pass parameters for the connection itself, but not for individual properties like ServerName or DatabaseName within the connection.

 
The use of dynamic content is indeed more limited. I am sure you have realized this during your testing.

 

Apologies again!

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!