Power BI: filter dataset based on another dataset result

Question

In this post, we will learn how to filter dataset based on another dataset result in Power BI Report Builder.

In some cases, you may need to show all rows in a specific dataset based on selected sections coming dynamically from DB. In this case, you have to use Internal Paramter by doing the following:

Steps

1. Create the first dataset - the main one which will use in filtration, for example customer_list
   
2. Create the internal parameter, for example "AllowedCustomer".
   
3. From left side click on "Available Values", and select "Get values from a query".
4. Then select the dataset from first step and fill value / label field.
   
5. From Left side click on "Default Values", , and select "Get values from a query".
6. Then select the dataset from first step and fill value field.
   
7. Create the socend dataset that need to filtered by first one, add the parameter in query, for example where customer_number in (@AllowedCustomer)
   
8. From left side click on "Parameters", and add the parameter to use in query and select the internal parameter from socend step.
   
9. Now test the project, you will find the data is filtered dynamically based on the first dataset result.

See also Install and Configure Power BI Report Server Step by Step