Power BI Report Builder Report Parameters not filtering properly

[josephliverpool]

Hi!

I have been tasked with building a paginated report in Power BI Report Builder so I have completed the SQL script, popped this into the query, validated it and it all works fine.

The only thing I am struggling with are the parameters. I have put the parameter together absolutely fine, it appears at the top of the page and the names I want to filter by all appear, however when I choose the name in the list (Smith for example), the data in the body of the report doesn't change, it still displays all of the rows data rather than just the name I have selected in the drop down.

Is there a way around this?

[ajohnso2]

Have you added the selected parameter value into your SQL?

I.e. WHERE Name = @pPersonName <(Name of your param)

[josephliverpool]

Nope haven't done that, I'm pretty new to report builder so didn't know I had to, can I just add this to the existing SQL script or does it have to be a seperate piece of SQL script?

[ajohnso2 · Accepted solution]

are you adding your sql directly to the report or are you running the sql via a stored procedure?

You should be able to add the where claus to your existing sql so something like 

SELECT Name

FROM Employees 

WHERE Name = @pEmployeeName

Alternatively (and i dont recommend this for a large dataset) you can edit your dataset, find the filters section and add a filter to your dataset using the parameter value.