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
Allow multi-column conditions /output in Power BI Activator rules (Power BI visual-based alerts)
Description: When I create an Activator alert from a Power BI report visual, the rule can only evaluate the single column or measure it was created from, and the alert can only reference that same v...AdityaPrasad2 hours agoHelper INew3Views0likes0CommentsFabric warehouse SQL editor: improve Ctrl-Enter
Today the Fabric warehouse SQL editor executes the full text in the editor when you press Ctrl-Enter without anything selected. It would be very convenient if Ctrl-enter only executed the single sql...stegus643 hours agoNew MemberNew3Views0likes0CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg6 hours agoNew MemberNeeds Votes7.9KViews1160likes105CommentsPower BI Dynamic Subscription Capacity Consumption and Recipient Processing
Issue: The concern is that the dynamic subscription workload can consume a significant amount of capacity when generating and distributing personalized report outputs. This creates a scalability conc...vivek1234417 hours agoMicrosoft EmployeeNew4Views0likes0Comments