Trying to setup parameters in Power BI dataflows

[tjravi2828]

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? Please refer screenshots.

 

 

 

[tjravi2828]

How do I do that? M-query does not show the dataflow name to replace it with parameter.

[aj1973]

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 .

[aj1973]

Hi @tjravi2828 

Dataflows storage is ADLS(Azure Data Lake Storage) therefore the parameters you have created are applied to the ADLS and when you call the Dataflow from your desktop (Through semantic model) you import the data that is already parameterized. 

I think if you want to switch between 2 hostnames in Databricks then you create 2 Dataflows (One for each Host) and then create parameters in the semantic model to switch between the 2 of them.