PowerBI Slicer value + Parameter and use in Snowflake Direct Query

[aviokc2011avi]

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 

List and Parameter Details below

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

Gives error 

Requesting help 

[Kejmil]

Hi,
Probably you are trying to add "text.from" function and parse it into a text value.

You cannot use a text value to parse it to another text value.

Note from documentation:

Text.From

Syntax

Text.From(value as any, optional culture as nullable text) as nullable text

About

Returns the text representation of a specified value.

• value: The value to convert to text. The value can be a number, date, time, datetime, datetimezone, logical, duration, or binary value. If the given value is null, this function returns null.
• culture: (Optional) The culture to use when converting the value to text (for example, "en-US").

[mgtaylor33]

Hi There, Even Later to this party, but it is pretty much exaclty the same issue I'm facing, has there been a solution found? and if so where?

[HS_PDS]

Little late to the party. 

We're you ever able to successfully take slicer input into a parameter and pass via direct query to snowflake query (table)?

I'm currently going to give this a try but wanted to see if its possible

[Daryl-Lynch-Bzy]

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