topic Multivalue Parameter Paginated Report Snowflake SQL as a source in Report Server

Multivalue Parameter Paginated Report Snowflake SQL as a source

Ritesh_Air — Thu, 03 Nov 2022 21:07:17 GMT

Hello,

Trying to figure out the multi-value parameter in Paginated report when Snowflake SQL is the source and running into issue.

#1. Tried this:

and I get this Query window:

Not sure, what to do with this. But if I cancel then it goes away but the query doesn't work.

I tried this link as well and that's where I got the string that is above. But I am not sure what am I doing wrong here?

https://community.powerbi.com/t5/Desktop/Using-ODBC-to-Snowflake-as-a-Datasource-within-Report-Builder/td-p/2377297

Any help is appreciated...

Ritesh

Re: Multivalue Parameter Paginated Report Snowflake SQL as a source

Anonymous — Fri, 04 Nov 2022 05:32:10 GMT

Hi Ritesh_Air ,

“Trying to figure out the multi-value parameter in Paginated report when Snowflake SQL is the source and running into issue.”

I don't quite understand your needs, what is the last problem you wish to solve?
It seems like there is a problem when Snowflake SQL is the source, can you describe in detail what the problem is?

Best regards.
Community Support Team_ Caitlyn

Re: Multivalue Parameter Paginated Report Snowflake SQL as a source

Ritesh_Air — Fri, 04 Nov 2022 05:57:04 GMT

Anonymous

Thanks for reply. I am trying to figure out what would be the code for myltivalue parameter? Just as a background, snowflake sql is the data source as an ODBC connector. I tried to follow the link I mentioned in my earlier message but it didn't work.

make sense?

thanks in advance,

Ritesh