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
  • 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!