Forum Discussion
Parameters in Dataflow Gen 2 - Deployment Pipelines
Can we use parameters in "Data Flow Gen 2" to change the data source between UAT and Prod workspaces when we use deployment pipelines?
Note: This is supported in Data Flow Gen 1, but I couldn't find a way to do it in Data Flow Gen 2. Does anyone have any workarounds?
Cheers,
Prasad.
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
2 Replies
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
Switching between sources isn't the real issue, but switching the actual destination is from what I understand. I am perfectly able to switch the workspace the source is coming from, but the destination is pretty much baked into the dataflow
