Forum Discussion
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 like I can't.
Am I using it wrongly?
If no, what is the inteneded use of parameters?
Also, I don't see any option for parameters in df settings which makes me think how one intended to use parameters in dataflow can change parameter values as they are not avaliable in settings
It is not an issue with dataset; it works seamlessly
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.
2 Replies
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.
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.
