Unable to Pass Multiple Values in slicer in Report Builder Paginated Report

[Koritala]

Hi All,

Can anyone share the Redshift Native SQL to pass multiple values to slicer in report builder paginated report with redshift db supported query onlt thorogh ODBC connector.

Appriciate if you can share the .rdl file once you build the report.

Thanks,

Koritala

[v-menakakota]

Hi  @Koritala  ,
Thanks for reaching out to the Microsoft fabric community forum. 

Please go through the below documents which may help you in ressolving the issue:
Pass a report parameter within a URL - SQL Server Reporting Services (SSRS) | Microsoft Learn
Add a multi-value parameter to a paginated report - Microsoft Report Builder & Power BI Report Build...

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

[Nasif_Azam]

Hey @Koritala ,

To pass multiple values to a slicer (multi-value parameter) in SQL Server Report Builder when connecting to Amazon Redshift via ODBC, you’ll need to construct your SQL query in a way that is compatible with Redshift’s limitations around multi-value parameters.

Basic Concepts

1. ODBC Limitations: Redshift doesn’t support table-valued parameters or IN (@Parameter) syntax directly when using ODBC with Report Builder.

2. Workaround: Pass multiple values as a comma-separated string, then split it within Redshift.

1. Create a Multi-Value Parameter

In Report Builder:

• Go to Parameters → Add a new parameter.

• Set Allow multiple values to checked.

• Name it something like @MyValues.

2. Concatenate Selected Values

Create a hidden parameter or internal parameter named @MyValuesCSV with this expression:

=Join(Parameters!MyValues.Value, ",")

3. SQL Query (Redshift-Compatible)

Here’s an example native SQL that works with Redshift ODBC:

SELECT *
FROM your_table
WHERE ',' || :MyValuesCSV || ',' LIKE '%,' || your_column || ',%'

Make sure your_column has no embedded commas. You may need to TRIM or REPLACE.

For detailed information:

Using Redshift with ODBC

Create Paginated Reports with Parameters

Use a Report Parameter to Filter Data

Paginated Reports with Amazon Redshift – Microsoft Power BI Blog

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[Koritala]

Hi Nasif, I tried your sql syntax and i am getting error. For your reference, here I am attaching screenshots of my sql and error. could you please let me know where it went wrong?

[Nasif_Azam]

Hey @Koritala ,

I am really sorry for late reply. Thank you for sharing the screenshots they helped identify the issue clearly. The root cause of the error is that Redshift’s ODBC driver does not support native parameter substitution using :parameter for multi-value inputs. Instead, we have to use a string-based workaround.

Revised Solution for Multi-Value Parameter with Redshift ODBC

Amazon Redshift via ODBC does not natively support multi-value parameters the same way SQL Server does. The setup:

1. Create Your Multi-Value Parameter

Make sure you’ve set the parameter to accept multiple values:

• Name: IncludeCode

• Type: Text

• Allow multiple values: Checked

2. Create an Internal/Hidden Parameter

This will join the selected values into a comma-separated string.

• Name: IncludeCodeCSV

• Type: Text

• Expression:  =Join(Parameters!IncludeCode.Value, ",")

Revised SQL for Redshift-Compatible Multi-Value Filtering:

SELECT *
FROM your_table
WHERE POSITION(',' || your_column || ',' IN ',' || :IncludeCodeCSV || ',') > 0

This checks if the column value exists within the CSV string.

Make sure:

• You use =Join(Parameters!IncludeCode.Value, ",") for your IncludeCodeCSV parameter (as you've shown).

• You avoid spaces and extra characters in parameter values.

Things to remember:

• Ensure there are no spaces in the CSV string.

• You can also TRIM() and REPLACE() if needed:

WHERE POSITION(',' || TRIM(your_column) || ',' IN ',' || REPLACE(:IncludeCodeCSV, ' ', '') || ',') > 0

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[Koritala]

Hi Nasif, Thanks for your support.

Still I am getting an error. For reference, here I am attaching the screenshots. please let me know your comments.

[v-menakakota]

Hi @Koritala ,

Can you try below query once

SELECT * 
FROM opsmianalytics.dm_fact_monthly_unit_movement_outbound_feed_vw 
WHERE POSITION(',' || level_one_fund_code || ',' IN @FundCodeListCSV) > 0

Best Regards, 
Menaka.
Community Support Team

[v-menakakota]

Hi @Koritala ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[Koritala]

Issue not resolved 

[v-menakakota]

Hi @Koritala ,

Thanks for your update. Could you please clarify what specific error or issue you're currently facing? This will help us better understand and assist you further.

Best Regards, 
Menaka.
Community Support Team

 

[Koritala]

Hi Menanaka, above is error I am getting 

[v-menakakota]

Hi @Koritala ,

It might be helpful to contact Microsoft Support. You can let them know what steps you've already tried they may be able to spot something.
Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Best Regards, 
Menaka.
Community Support Team

[v-menakakota]

Hi @Koritala ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[Koritala]

Hi Menaka,

Thanks for your follow up.

Unfortunately, we don't have enterprise license and not having budject to take the paid session from technical team, still issue is not resolved.

Thanks,

Srinivas.

[v-menakakota]

Hi @Koritala ,
Thank you for the update.

If you are part of any role you can create support ticket.

Best Regards, 
Menaka.
Community Support Team

[Koritala]

Hi Nasif,

May I know how to create an internal parameter as per 2nd point in your post.

Also, can you let me how and where we create internal or hidden parameter?

What is the difference between @MyValues and @MyValuesCSV ?

Thanks,

Koritala

[Koritala]

Hi Nasif,

Could you please share the sample .rdl file for my better understanding? Becuase I followed above steps sometime back and I couldn't achived the result.

Thanks

Koritala