Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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!
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!
Do you know if anything is in the roadmap to remedy this?
It would avoid having to make more complex developments, initially with Fabric (which will have to be changed and simplified later).
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
29 | |
15 | |
6 | |
6 | |
3 |
User | Count |
---|---|
50 | |
44 | |
15 | |
7 | |
6 |