Forum Discussion
Adding Parameter to second dataset
In Power BI Report Builder, I have two Datasets (DataSet1 and DataSet2). On my Table, I have two columns, one column comes from DataSet1 and another is an expression to do a Lookup to get a column from DataSet2. I want to add a Parameter to DataSet2, so that I can restrict the values in the Lookup, but I get an error "The parameter <ccon>@PARAM/ccon> is not referred in the query." Any ideas how to do this?
thanks!
Check these links and see if it helps:
https://community.fabric.microsoft.com/t5/Desktop/Report-Builder-Parameters/td-p/2250770
If this is not fixed, reply with the type of data source you are using.
FYI, For SQL, it may be simple steps, for DAX, little more steps.
4 Replies
Check these links and see if it helps:
https://community.fabric.microsoft.com/t5/Desktop/Report-Builder-Parameters/td-p/2250770
If this is not fixed, reply with the type of data source you are using.
FYI, For SQL, it may be simple steps, for DAX, little more steps.
The first link showed me the syntax I needed to make this work. thank you!
Feedback only as I don't have a way to test. In Power BI Report Builder, you can indeed add parameters to datasets to restrict the data based on user input. However, when using a parameter in a Lookup expression, you need to ensure that the parameter is actually used in the dataset query. The error message you encountered indicates that the parameter is defined but not referred to in the query.
How do I ensure the parameter is actually used in the dataset?
Sorry, let me try to re explain my situation. I have two Datasets that I refresh on a daily basis. I am creating a Paginated Report that pulls fields from both datasets. Since I'm not working with a model, I can't create a relationship between the two Datasets, so I use a Lookup expression to get the fields from the second Dataset. However, I want to allow the user to limit the data in the second Dataset, so I attempted to create the parameter in the second dataset under "Dataset Properties" -> "Parameters".
