Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Using parameters to change workspace name for getting dataflows

Hello,     My PowerBI desktop is pulling data from dataflows. I have a set of dataflows that point to my development server in a workspace named tstdataflows and a list of dataflows that point to m...
Need Help
chrissto's avatar
chrissto
Frequent Visitor
3 years ago

Hey Anonymous ,

 

maybe I come to late to the party, but I solved this in the advanced editor with follwoing query:

let
    Source = PowerPlatform.Dataflows(null),
    Workspaces = Source{[Id="Workspaces"]}[Data],
    #"ws" = Workspaces{[workspaceName=#"Workspace"]}[Data],
    #"df" = #"ws"{[dataflowName=#"Dataflow"]}[Data],
    Table= #"df"{[entity="Fakt_Mieter",version=""]}[Data]
in
    Table