topic Re: Paginated Report - Snowflake SQL as data source in Report Server

Paginated Report - Snowflake SQL as data source

Ritesh_Air — Wed, 26 Oct 2022 05:43:01 GMT

Has anyone used Snowflake SQL as a datasource for their Paginated report?

I am trying to do the cascading prompts and get the value from one query and putting it in the 2nd one but getting issue.

Here is more detail:

Here are the steps I have done:

1. Data Source connection is : ODBC/Snowflake.
2. First dataset: Simple SQL query to get "Parent" Info.

select RETAILER_NAME
from table where Enrollment_Year = 2022

3. Second dataset: Simple SQL query where I am referencing the parameter. In this case, it is :Parent

select Program_Group_Name
from "table" where Enrollment_Year = 2022 and Retailer_Name = :Parent

I have Parameter here:

Defined it Here:

Here is the RDL report for reference.

https://drive.google.com/file/d/1QFjCHQOdqUKIov_ST5iY6vf6RxlEkkNq/view?usp=sharing

Re: Paginated Report - Snowflake SQL as data source

d_gosbell — Wed, 26 Oct 2022 06:55:05 GMT

Not all ODBC drivers support parameters in the same way. You could possibly try using ? as a positional parameter in your query instead of using :Parent

This appears to have worked for this person Solved: Re: Using ODBC to Snowflake as a Datasource within... - Microsoft Power BI Community

Re: Paginated Report - Snowflake SQL as data source

Ritesh_Air — Wed, 26 Oct 2022 20:19:01 GMT

d_gosbell You were god send. This is exactly what I was looking for. The link and the youtube video were very helpful.

Thank you so much! I might tag you about Row Level security in Pagainted report next 🙂 to see if you have pointers.

-EZ