Hschwarz
Microsoft Employee
8 months agoStatus:
New
Dynamic Variable Library Access in Fabric Pipelines
Current Pain Point
Currently, when using Variable Libraries in Fabric pipelines, each variable must be manually added one-by-one to a pipeline before it can be referenced. This creates significant friction, especially when:
- Working with libraries containing dozens of variables
- Adding new variables to an existing library (requires updating every pipeline that needs them)
- Managing multiple environments with different configurations
Proposed Solution
Allow dynamic access to Variable Library variables without pre-registering them in each pipeline. Two implementation options:
Option A: Link Entire Variable Library
- Add capability to link a full Variable Library to a pipeline
- All variables in that library become immediately accessible
Option B: Dynamic Expression Function
@GetVariable('VariableLibraryName', 'VariableName')- Reference any variable from any Variable Library in the workspace dynamically
- No pre-registration required
- Enables truly parameterized, reusable pipelines
Benefits
Benefit Impact
| Maintainability | Add variables once to the library, use everywhere instantly |
| Reduced Errors | No more forgetting to add variables to pipelines |
| DRY Principle | Single source of truth for configuration values |
| CI/CD Friendly | Easier to manage environment-specific configs across deployments |
| Developer Experience | Faster pipeline development, less repetitive clicking |
Use Case Example
Imagine a data platform with 50+ pipelines all needing access to common configuration values (connection strings, retention days, environment flags). Today, adding one new variable means manually updating all 50 pipelines. With dynamic access, you update the library once and you're done.
No CommentsBe the first to comment
Recent ideas
Disable App Sharing Notification to Audience
Can we have the option to turn off the notification when we add people to an audience in Power BI Apps? Sometimes, I want to share an app with a wider group of people, but I don't want to notify all ...Donaldsoncc3 hours agoNew MemberNew2Views0likes0CommentsUser Interface customization - HomePage & Help and support
Hi, 1st idea: It would be great if administrators could customize the Fabric/Power BI Home page. Today, users can choose between three predefined layouts (Copilot, Simplified, and Expanded). Allowin...XCT6 hours agoResolver INew4Views0likes0CommentsSort Group Members Alphabetically in Power BI
When creating or editing groups in Power BI Desktop, the values displayed under“Groups and members” are not sorted alphabetically. When working with large lists, this makes it unnecessarily difficul...Macpanzer6 hours agoNew MemberNew3Views0likes0CommentsOverview of all Item permissions in a Workspace
We need a single page overview where we can see a complete list of which users and security groups have item permissions on any Item in the workspace. Today, we need to click on every single It...frithjof_v8 hours agoCommunity ChampionNew1.3KViews14likes3CommentsSupport report-level DAX measures in Power BI Publish to web
Report-level measures are especially useful for thin reports that connect to a shared semantic model. They allow report authors to create calculations required only for a particular report without mo...v-viputta19 hours agoMicrosoft EmployeeNew12Views4likes0Comments