Forum Discussion
Trying to setup parameters in Power BI dataflows
I am trying to setup parameters (for Azure Databricks Datasource DEV, TEST & PROD) in dataflows in Power BI Service. They are not visible under Dataset/Semantic Model settings. What am I missing here...
How do I do that? M-query does not show the dataflow name to replace it with parameter.
Hi tjravi2828
It is not the Dataflow that you need to parameterize. it is the entity.
These are the "Entities" of a Dataflow
So let's you create a Dataflow in a Workspace. In the Dataflow you will add one entity for each server or environment (Dev, Test, Prod). When you Get Data in your desktop to build your dataset, In Power Query you create parameters for each Entity.
In your case where you have 3 Workspaces (Dev,Test and Prod) with 3 Dataflows, you will then create parameters for each Workspace ID and Dataflow ID. I hope you know where to get the IDs .