Parameters in Dataflow Gen 2 - Deployment Pipelines

[Prasad-DA]

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.

[belkov78]

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

[nilendraFabric · Accepted solution]

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

https://www.reddit.com/r/MicrosoftFabric/comments/1en5e54/an_interesting_solution_to_deployment_pipe...

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

@Prasad-DA