Paginated Reports in Report Builder - How to use one parameter to filter on multiple datasets?

[MCubedMama]

Building out paginated reports in Report Builder and I need to filter on multiple tables with one parameter. I have a Customer fact table and a Notes dim table. They have a Customer Id in each table and I need to bring in only the notes from the dim table that is filtered on the customer ID from the Fact table. Right now it is currently bringing in all the notes in the table.  This is pulling in data from a Power BI dataset. Any help on this would be greatly appreciated. Thank you!

[Anonymous · Accepted solution]

Hi @MCubedMama ,

You can follow the steps below to get it:

1. Create a parameter CustomerID

How To Create Parameters In Power BI’s Report Builder 

2. Modify the query adding with parameter in Query Designer for every dataset

WHERE CustomerID = @CustomerId

Add a filter to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft ...

Bet Regards