Forum Discussion
Parameters in Dataflow Gen 2 - Deployment Pipelines
hello
Currently, Dataflow Gen 2 in Fabric does not natively support deployment pipelines, which makes it challenging to use parameters to dynamically switch data sources (e.g., between UAT and Production workspaces) during deployments
Try this :Use dynamic logic in your queries to determine the workspace or data source based on the current environment.
- Use a system variable like WorkspaceID to identify the environment.
- Implement conditional logic (e.g., if statements) within Power Query to switch between data sources based on this variable
This solution is not perfect m, but worth trying
If this helps ,please accept the solution and give kudos
hello
Currently, Dataflow Gen 2 in Fabric does not natively support deployment pipelines, which makes it challenging to use parameters to dynamically switch data sources (e.g., between UAT and Production workspaces) during deployments
Try this :
Use dynamic logic in your queries to determine the workspace or data source based on the current environment.
- Use a system variable like WorkspaceID to identify the environment.
- Implement conditional logic (e.g., if statements) within Power Query to switch between data sources based on this variable
This solution is not perfect m, but worth trying
If this helps ,please accept the solution and give kudos