Hschwarz
Microsoft Employee
7 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
Power BI - incorrect handling of empty string parameter in DAX query in paginated report
Blank string parameters in paginated reports are treated as empty strings in Power BI Report Builder but as null values in the Power BI Service, resulting in incorrect report output. -> Create a pag...roshinikumarkar2 hours agoMicrosoft EmployeeNew20Views5likes0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara3 hours agoNew MemberNew17Views1like1CommentAllow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels10 hours agoAdvocate IIINew187Views0likes2Comments