In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection to create a parameter but that doesn't exist for a dataflow. This means that it is a bit fidly requiring creation of a parameter seperately then amending the advanced editor M code.
Could we get an options cog on the navigation step that allows the easy creation of or reference to parameters for dataflows and workspaces.
These are essential as we are working with dataflows and deployment pipelines and often switch between dataflows for testing but setting them up n power query is arduous.
on:
CI/CD support for Notebook Resources folder
tbindas-msft
on:
Add Object, Workspace and User details to Capacity...
on:
Variable Library: Shortcuts with variable value th...