topic Re: Fabric pipeline Deployment dev to prod in Data Warehouse

Fabric pipeline Deployment dev to prod

AJAJ — Tue, 20 Jan 2026 16:30:48 GMT

Hi there,

I have been developing fabric data pipelines, warehouse, lakehouse in a fabric dev workspace. I noticed when deployment is done from WS_Dev to WS_Prod, pipelines are still pointing to Dev workspace. I can parameterize it.

Where in Prod workspace do I need to configure that all objects should point to Prod workspace so code deployments from dev dont overwrite the variable in PROD.

master pipeline with look up

After lookup -- invoke pipeline

child pipeline with copy activity.

Re: Fabric pipeline Deployment dev to prod

deborshi_nag — Tue, 20 Jan 2026 21:55:26 GMT

Hello AJAJ

You can utilise parameter variables within the connection field of Fabric Data Factory activities, though only in certain circumstances. At present, Microsoft Fabric does not support full parameterisation of the connection object itself; however, it is possible to parameterise the connection ID by leveraging dynamic content, pipeline parameters, or—preferably—Variable Libraries.

How you can use this approach:

1. Using parameters within the “connection” field

Fabric permits the use of dynamic content (parameters) in the connection field, provided the value supplied is the Connection ID (GUID).

Community feedback affirms that you may assign the connection field to @pipeline().parameters.<yourParam>, assuming the parameter contains the connection GUID.

2. Locating the connection ID

To obtain the connection ID:

Navigate to Manage connections and gateways
Select the relevant connection
Copy the Connection ID (GUID)

3. Variable Libraries (recommended practice)

As direct parameterisation of connections is not currently supported, Microsoft recommends the use of Variable Libraries as the endorsed solution.

Store connection IDs in the variable library
Maintain different value sets for Dev, Test, and Prod environments
Reference these variables within your activities

Re: Fabric pipeline Deployment dev to prod

AJAJ — Wed, 21 Jan 2026 22:15:07 GMT

Thanks deborshi_nag . I never thought i should use the connection guid instead of connection name.

How about work space parameterization?

How to make sure fabric deployment pipeline does not overwrite parameter value from dev pipeline.

Re: Fabric pipeline Deployment dev to prod

deborshi_nag — Thu, 22 Jan 2026 09:11:18 GMT

Hi AJAJ

This is how you can ensure deployment pipeline doesn't overwrite the GUID

Open your Deployment Pipeline.
Go to the Test stage → Manage rules.
Add a rule for Variable Library Value Set.
Choose Value Set = Test.
Repeat for Prod.

Now:

Deploy Dev > Test > Dev GUID NEVER overwrites Test GUID
Deploy Test > Prod > Test GUID NEVER overwrites Prod GUID

Re: Fabric pipeline Deployment dev to prod

v-saisrao-msft — Tue, 27 Jan 2026 04:07:35 GMT

Hi AJAJ,

Have you had a chance to review the solution we shared by deborshi_nag? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Fabric pipeline Deployment dev to prod

v-saisrao-msft — Fri, 30 Jan 2026 04:18:57 GMT

Hi AJAJ,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

Re: Fabric pipeline Deployment dev to prod

stoic-harsh — Fri, 30 Jan 2026 11:20:30 GMT

Hi AJAJ,

Deployment Pipelines in Fabric doesn't automatically remap environment-specific references (Lakehouse, Warehouse, connections). This is by design.

The most reliable way to align pipelines across Fabric workspaces is to export the pipeline JSON, replace Dev artifact IDs with Prod IDs, then import it into Prod. Basically, configure Prod Pipelines using JSON templates from Dev after replacing IDs.

Re: Fabric pipeline Deployment dev to prod

dhirtzbruch — Thu, 11 Jun 2026 10:46:25 GMT

Hi deborshi_nag ,

any idea why I cannot find or add rules for my variable library?
I open the rules on our prod workspace here:

But in the dialog our variable library is not even listed.

Feedback much appreciated!