Question: Issue with Multiple Parameter Values in Power BI Paginated Report

Hi gautampruthi ,

Thank you for reaching out to Microsoft Fabric Community.

You are encountering this issue due to the highlighted statement below. When passing parameters, only the distinct values selected through filters in the paginated report are used. The report cannot run without selecting any values. If no selection is made, it will result in an error as shown in the screenshot below. To fix this replace
AND (@crs_facc IS NULL OR srs_crs.crs_facc IN (@crs_facc)) with AND (srs_crs.crs_facc IN (@crs_facc))

Script which is causing error: 

AND (@crs_facc IS NULL OR srs_crs.crs_facc IN (@crs_facc))

Error screenshot if we don't select any value in for the parameter.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!