Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Paginated report with multi valued parameter not working

Hi,   I am trying to pass muliple values in the paginated report, i.e. not multiple parameters.   For instance I am trying see users aged 21, 22, 23, when I am passing 21 it works fine. But when ...
Need Help
Narukkp's avatar
Narukkp
Helper V
5 years ago

Hi Team,

 

How we can achive the same in source as sql in report builder. In above example source as power bi report in report builder so that we can use that dax expressions but in my case source as sql server in report builder and using URL action we are trying to call the power bi serice report in report builder and it is working as expected for single selection but multi selection parameters it is not working

Neka's avatar
Neka
Helper III
3 years ago

I know this post is super old but in case it helps anyone else with this problem. I solved this issue when using a stored procedure that connected to my paginated report. You need to add the following code to your WHERE clause in the stored procedure: 


WHERE YourDesiredField IN(SELECT TRIM(value) FROM STRING_SPLIT (@YourParam, ',')).  

This will split up the multiselect into individual strings instead of showing as one giant string. This is why no data shows up in the report with the multiselect, because it shows up as 'Item1, Item2, Item3' instead of 'Item1', 'Item2', 'Item3'.