Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

Using Parameters in dataflow

Is there a way to use paramters in dataflow? I am passing on the parameter to a ssas query.   I am currently running into this. I want to be able to utilize parameters in a df Query but looks lik...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi smpa01 - this is a limitation of Power BI Dataflows - Link to Limitations  "In Power BI dataflows, you can use parameters but you can't edit them unless you edit the entire dataflow. In this regard, parameters in dataflows behave similar to declared constants."

     

    The work around is to define the parameter in another Data Source (e.g. Excel file or SharePoint list) and import into the dataflow.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi smpa01 - this is a limitation of Power BI Dataflows - Link to Limitations  "In Power BI dataflows, you can use parameters but you can't edit them unless you edit the entire dataflow. In this regard, parameters in dataflows behave similar to declared constants."

 

The work around is to define the parameter in another Data Source (e.g. Excel file or SharePoint list) and import into the dataflow.

  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    This is simply no good and in my opinion defeats the purpose of a having a const in the form of parameter which cant be controlled externally outside of a df unlike in dataset. I would not know what is the purpose of having a const controlling which needs one to go inside the query every time there is a req. It does not make sense to me. I would stick with parameter in dataset.