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

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!