Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
aviokc2011avi
Regular Visitor

PowerBI Slicer value + Parameter and use in Snowflake Direct Query

Hi All 

I have a 2 Slicers , 2 Parameters and Query. I am trying to get values from Slicers( Lists) and Pass that to parameter and use the parameter in Snowflake Direct Query 

Slicer Details below 

aviokc2011avi_1-1670296041881.png

List and Parameter Details below

 

aviokc2011avi_2-1670296153028.png

 

When i try to use the parameter in direct query as below 

aviokc2011avi_3-1670296465294.png

Gives error 

aviokc2011avi_4-1670296526908.png

Requesting help 

 

 

1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @aviokc2011avi  - a couple of questions:

  1. What does the "See Details" error message say?
  2. Did you bind the Parameters to Slicer in the Data Model?  Step 9 in documentation Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors