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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vivien57
Advocate III
Advocate III

Environment configuration : Setting environment variables at Workspace level

Hello everyone,

I don't know if, like me, you find that the variability of environments in Fabric is not up to scratch...

In fact, with our good old SSIS, and our SSIS Catalog, it was possible to variabilise our developments and then in the SSIS Catalog we once recorded the values in the DEV, UAT and PROD environment and then each time we deployed, depending on the environment, the correct connections were used.

In Fabric, it's possible to create parameters in a Data Pipeline, a DataFlow, but it's not possible to configure whether these items are in the Dev workspace, they take these values, or if it's in the prod workspace, these values.

In my opinion, it should be possible to register variables/values at the Workspace level.

I've tested this with the deployment rules in the deployment pipelines, but DataFlow isn't supported and I can't configure the value of the parameter in the data pipeline.

In short, I don't think there's a solution for managing this effectively.

What do you do? Do you also think that centralised management at workspace level would be relevant?

Thank you in advance for sharing your experience.

Vivien

1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hi @vivien57 

 

This feature is not available at the moment. I understand the inconvenience this may cause. You can vote for similar ideas below or suggest a new one in Fabric Ideas forum to inform the product team of your requirement. Two of these ideas are marked as 'Planned', indicating that the feature is probably on the roadmap but not yet ready for public release. Please continue using Fabric and follow the Fabric blogs for the latest updates.

Microsoft Idea: Data Pipeline Global Parameters Support 

Microsoft Idea: Workspace-Level Parameters

Microsoft Idea: Global Parameters in Fabric Data Factory

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

2 REPLIES 2
v-jingzhan-msft
Community Support
Community Support

Hi @vivien57 

 

This feature is not available at the moment. I understand the inconvenience this may cause. You can vote for similar ideas below or suggest a new one in Fabric Ideas forum to inform the product team of your requirement. Two of these ideas are marked as 'Planned', indicating that the feature is probably on the roadmap but not yet ready for public release. Please continue using Fabric and follow the Fabric blogs for the latest updates.

Microsoft Idea: Data Pipeline Global Parameters Support 

Microsoft Idea: Workspace-Level Parameters

Microsoft Idea: Global Parameters in Fabric Data Factory

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

vivien57
Advocate III
Advocate III

Do you know if anything is in the roadmap to remedy this?

vivien57_1-1723210223235.png

It would avoid having to make more complex developments, initially with Fabric (which will have to be changed and simplified later).



 

 

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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