Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
8 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 months ago

    Hi Koritala,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


    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.