Filtering with a sub filter with multiple value selection - will not work for Report Builder PR

Hi, Karolina411 

Thank you for your reply. I also encountered the error you mentioned during the test. Here is how to solve it:

Here are the parameters and dataset I currently have, I will reproduce your error and suggest a solution in the steps below:

I get your error when I follow the steps below to create a dataset:

Here are the correct steps:

The main reason was that the parameter we created (report level) was not correctly recognized by the query engine even though I bound it correctly. My correct steps above utilized the query parameters generated by the query designer and then manually bound to our existing parameters.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.