Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
9 months ago

Need Help in Passing Dynamic parameters in main dataset

Hi All, Can anyone share the sample code to pass the parameters dynamically into main dataset(where report use the table). My source is redshift views and I have a prompts on different dimensions. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 months ago

Hi Koritala,

I would also take a moment to thank krishnakanth240, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
8 months ago

Hi v-hjannapu,

I followed the krishna's steps and not able to get the result.

for everyone reference, here I am attaching error screenshots.

 

Thanks,

Sri

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 months ago

    Hi Koritala,

    Thanks for sharing the screenshots.

    The problem is happening only because of multi-value parameter selection with Amazon Redshift.

    In Report Builder, when you select multiple values, it sends them to the dataset as a single comma-separated value example: North, South. Redshift does not support using this directly in the IN condition like SQL Server. Because of this, the dataset query fails and the report preview shows errors.

    That is the reason Single value selection is working, Multiple value selection is failing

    This is a limitation with Redshift + Paginated Reports, not an issue with your report design.

    To handle this, the filtering needs to be done either inside the Redshift view itself, or by splitting the values using Redshift-supported functions, or by building the query dynamically in the dataset expression. There is no direct out-of-box support for multi-value parameters with Redshift in Report Builder.

    Hope this explains the behavior clearly. Let us know if you want help with any workaround.

    Regards,
    Community Support Team.

    • Koritala's avatar
      Koritala
      Icon for Post Patron rankPost Patron
      8 months ago

      Hi v-hjannapu,

      Thanks for your explanation.

      can you help in how to write  building the query dynamically in the dataset expression by taking 2 dynamic parameters for my understanding.

      Also, one more issue I am struggling that, I was trying to enable the query folding option witht he Resshift table by writing the custom sql (select col1,col2 from tablename) and followed the steps in M code as per the process. But View Native SQL option is not at all enabling. Could you please check this from your end if possible and confirm me? Becuase there is less  support I am getting from the either internet or Microsoft documentation as Redshifta and Power BI are rare combination or different vendors.

      Thanks,

      Sri.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 months ago

        Hi Koritala,
        Thanks for checking and for explaining the issues clearly.

        For Amazon Redshift, the reliable way to handle multi-value parameters in Paginated Reports is by building the SQL dynamically using the dataset query expression (fx). Native multi-value parameters are passed as a single comma-separated string, which Redshift does not support directly in the IN clause.

        Regarding Query Folding / View Native SQL, this behavior is expected. When using Redshift with custom SQL or dynamic queries, query folding isn’t supported, so the option remains disabled. This is a limitation of the Redshift connector rather than the report configuration.

         

        Regards,

        Community Support Team.