Skip to main content

Power BI

New

PowerPlatform.Dataflows connector - Nav by name instead of GUID toggle

Vote (1) Share
Chris Meurer's profile image

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_"