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 my production server in prddataflows. I would like to use parameters to switch bwetween my test and production workspaces. I have enabled parameters in the destop client, but am unable to tell where to put the parameter name. Any advice?

 

Cheers,

 

Peter

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,

       

        I created the Dataflows query mentioned in the articles. I have verified that the Dataflows[workspaceId] and Dataflows[Catalogtype] have the correct vlaues in for the workspace ID and dataflow id. I updated my dataflow source to be the following:

       

      let
      Source = PowerBI.Dataflows(null),
      #"Step1" = Source{[workspaceId=Dataflows[workspaceId]]}[Data],
      #"Step2" = #"Step1"{[dataflowId=Dataflows[CatalogType]]}[Data],
      CatalogType1 = #"Step2"{[entity="CatalogType"]}[Data]
      in
      CatalogType1

       

      it seems to fail on line 5 when I try to create the Catalogtype entity with the following error:

      All I am trying to do is easily switch between my test and production environments.

       

      Cheers,

       

      Peter

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Update: just to clarify:

      here is my Dataflow source for my CatalogType datasource:

      let
      Source = PowerBI.Dataflows(null),
      #"Step1" = Source{[workspaceId="827b08we-92b9-4188-bb0e-c46484fb39d8"]}[Data],
      #"Step2" = #"Step1"{[dataflowId="8a898189-fe4d-4b8b-97w2-f983f399d77c"]}[Data],
      CatalogType1 = #"Step2"{[entity="CatalogType"]}[Data]
      in
      CatalogType1

       

      And that will show me all of the data in the CatalogType datasource.

       

      I have a query called Dataflows that lists the workspaceid in a column called workspaceId, and the dataflowId in a column called CatalogType

       

      How do I replace the long strings in the datasource with the column values in the Dataflows table?

       

      Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Any ideas onthis issue?

  • 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