Paginated Report - Snowflake SQL as data source

Power BI Software & Tools
1

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
  1. 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:

image
image1085×366 8.59 KB

Defined it Here

image

Error:

image
image980×485 15.1 KB

Here is the RDL report for reference.

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

TIA
-EZ

2

Hi @dillenbram ,

We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!