Forum Discussion
Paginated report with multi valued parameter not working
Community SupportHi Anonymous ,
Based on my research, We need to set Allow multiple values property for the parameter, please refer to this document: https://docs.microsoft.com/en-us/power-bi/report-builder-parameters#bkmk_Report_Parameters
If you need to Pass a report parameter in a URL , The format for a multi-value parameter is to repeat the parameter name for each value. please refer to the example in this document: https://docs.microsoft.com/en-us/power-bi/report-builder-url-pass-parameters#additional-examples
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-lid-msft ,
I have set the parameter to be multi valued and also in the dataset I have set the default to select all the values as showed in the below video.
https://www.youtube.com/watch?v=KYfhclGrI48&t=922s
Regards,
Prime
- v-lid-msft
Hi Anonymous ,
How about the result if you repeat the parameter name for each value in a URL?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi v-lid-msft ,
I have managed to send the selected parameters using the concatenatex function, i.e. to split using a comma.
But in the Paginated report when I try to run the report by passing multiple values it give me blank records and when I use one value then it works fine.