Forum Discussion
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
List and Parameter Details below
When i try to use the parameter in direct query as below
Gives error
Requesting help
4 Replies
Hi aviokc2011avi - a couple of questions:
- What does the "See Details" error message say?
- 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
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
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?
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").
