Maximum Items in Multivalue parameter

Hi Sobha ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

In Power BI Paginated Reports, multi-value parameters are natively supported and can be passed to a backend database as a single comma-separated string. This is particularly useful for your scenario, where you need to send 3000–4000 items (each 10 characters long, totaling approximately 33,000–44,000 characters) to a stored procedure to avoid IN clause limitation of 1000 items. Power BI Paginated Reports allows you to concatenate the selected parameter values into a single string using a custom expression, which can then be passed to a stored procedure for parsing.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.