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