Forum Discussion

Koritala's avatar
Koritala
Post Patron
1 year ago
Solved

Redshift Native SQL is not supporting to pass the multiselect parameters in report builder

Hi, I was trying to write custom SQL with ODBC connector for redshift view. In fx option in report builder, when I write my redshift SQL like, select * from sales where region IN @regionparameter ...
Need Help
Koritala's avatar
Koritala
Post Patron
1 year ago

Hi 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? 

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi Koritala ,
As per this document not all data sources support parameters

Source: 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

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    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's avatar
    Koritala
    Post Patron
    1 year ago

    Hi nmadadi, issue not get resolved.

    I have followed all steps what people has mentioned in this thread. If anyone tried with redshift db table this is issue, I would appreciate if they can share .rdl file here. Because many are giving sample code on their assumptions. May be that is the reason it took this much time. If you can share sample file which worked from your end, it will be helpful.

     

    Thanks for your follow-up.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Koritala ,
    I understand that the issue still persists even after trying all the mentioned troubleshooting steps, but developing rdl with redshift DB data source fall ouside our scope, it will be helpful if you can raise a supprt ticket and let the team to look into the issue thouroghly, they will be able to find the root cause and fix the error.

    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Koritala ,

    Just checking in to see if you have raised a Microsoft support ticket. If it’s been taken care of, we’d really appreciate it if you could share the resolution or any key insights here it might help others facing similar challenges.

    If there’s no update, we’ll plan to close this thread soon.

    For any future queries, feel free to create a new post in the Microsoft Fabric Community Forum. We're always happy to assist.

    Thanks again for your contribution to the community.