Forum Discussion
Adding Parameter to second dataset
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.
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".