Forum Discussion

tjravi2828's avatar
tjravi2828
Frequent Visitor
2 years ago

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...
Dataflow
aj1973's avatar
aj1973
Community Champion
2 years ago

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.