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

 

 

 

Dataflow

3 Replies

  • 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.

     

  • tjravi2828's avatar
    tjravi2828
    Frequent Visitor
    2 years ago

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

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      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 .