Forum Discussion
Simplify and improve visualisation for variable library importation within pipeline
Hi LouisPaulVlx,
As AntoineW stated,
Today the pipeline UI only lets you link library variables one at a time, and there is no grouping in the Variables pane. That is expected for the current preview.
To avoid the 40-click setup, I’d switch from “many variables per source” to a single config per source and parse it inside the pipeline: Put one JSON string per source in the Variable Library,
e.g. SRC_A_Config = {"Server":"...","Db":"...","Table":"...","Key":"..."}.
In your activity settings, read fields with the expression builder, for example: @json(pipeline().libraryVariables.SRC_A_Config).
This reduces each source from 10 linked variables to exactly 1, while still letting you parameterize everything. Variable Libraries and pipeline integration are documented here: Variable library integration with Data pipelines and the Variable Library overview/get-started docs here: Overview, Get started
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi AntoineW , @tayloramy,
Thanks for your quick replies. Actually I thought to be in the idea section, following a call I had with Microsoft Support.. I'm new to this forum. Do you mind helping me creating this idea ?
Also, that's a good workaround @tayloramy. However, I'm the only one with technical experience on this project, and it need to stay simple for the other users who might change those in the future.. That's why I also liked the reading clarity with the library variable feature.
Hi LouisPaulVlx,
You can submit an idea here: https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.