Chris Meurer on 31 Mar 2022 19:36:36
I would like an option to allow us to have the generated power query that results after navigating a dataflow source using the PowerPlatform.Dataflows connector which enables us to specify to navigate by Workspace / Dataflow name (as opposed to the default of GUID)
In our environment, we sometimes need to make changes to dataflows that require us to drop the entire dataflow and re-create it from JSON. This results in a new GUID being assigned to the dataflow - which breaks connections to that dataflow in every report authored against it. Switching to Name makes this more flexible - I can specify the dataflow name when I create it, but I can't specify the GUID.
Instead of:
let
Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data],
#"00000000-8758-0000-b41e-000000000000" = Workspaces{[workspaceId="00000000-8758-0000-b41e-000000000000"]}[Data],
#"f0000000-8758-0000-b41e-000000000000" = #"00000000-8758-0000-b41e-000000000000"{[dataflowId="f0000000-8758-0000-b41e-000000000000"]}[Data],
#"INC & WO_" = #"f0000000-8758-0000-b41e-000000000000"{[entity="INC & WO",version=""]}[Data]
in
#"INC & WO_"
We would have the option to generate:
let
Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data],
#"my workspace" = Workspaces{[workspaceName="my workspace"]}[Data],
#"dataflow" = #"my workspace"{[dataflowName="dataflow"]}[Data],
#"INC & WO_" = #"dataflow"{[entity="INC & WO",version=""]}[Data]
in
#"INC & WO_"