Paginated Report - Snowflake SQL as data source

[Ritesh_Air]

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

[d_gosbell · Accepted solution]

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

[Ritesh_Air]

@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