Forum Discussion
Redshift Native SQL is not supporting to pass the multiselect parameters in report builder
Hi Koritala ,
As per this document not all data sources support parametersSource: Report parameters in Power BI Report Builder - Power BI | Microsoft Learn
If you still feel the issue is important and not related to source. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you
Hi Ajay, I tried your code, but unfortunately, it did not work. For everyone reference, here I am attaching the screenshots.. please advise anything I missed. I have tried to pass a single selection in my slicer in report bilder as per screenshot.
Hi Koritala ,
As a troubleshooting step,
Please check if the parameter is configured correctly in report server itself, test it out by running on the report directly.
Additionally to check if the issue is related to the particular parameter or the syntax of the code, please run some other simple SQL code with the same parameter and test it out.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
Hi nmadadi,
I have configured the parameter 100% correctly only.
My undxerstanding is we are not able to query which is not as per the redshift db norms. My SQL is very simple. We are failing to write the proper syntax for parameters.
If you have any questions, plz let me know.
Thanks,
Koritala
Hi Koritala ,
1) You might not be able to configure Parameters as both "Multi-value" and "Allow null".
"Multi value" and "Allow blank" is an allowed combination but Null is treated differently.
source: Power BI Report Builder - Power BI | Microsoft Learn
Check if that is causing the error you are facing.
2) Also verify if the parameter value you are trying to pass are of the correct data type and matches the source columns data type.
3) To resolve the error and validate the query syntax, replace the parameter @lfundcode with a hard-coded comma-separated string directly in the query:FROM regexp_split_to_table('ABC123,DEF456', ',') AS valueThis allows you to confirm that the logic for filtering level_one_fund_code works as intended.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank youHi nmadasi,
Thanks for your response.
I have configured the parameters data types properly. But still not working. Can you send me a sample rdl file for reference?