Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
josephliverpool
Frequent Visitor

Power BI Report Builder Report Parameters not filtering properly

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?

1 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 

ajohnso2_1-1721316676435.png

 

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.

 

ajohnso2_0-1721316635028.png

 

View solution in original post

3 REPLIES 3
ajohnso2
Super User
Super User

Have you added the selected parameter value into your SQL?

 

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

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?

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 

ajohnso2_1-1721316676435.png

 

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.

 

ajohnso2_0-1721316635028.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors