Dynamic m query parameters in power bi desktop with odbc connection

[s2joshi]

Hello,

My problem is that I am trying to use an ODBC connection to connect to a Snowflake stored procedure to retrieve data from Snowflake into Power BI.
I can get the data, but the problem is that I want to use a Dynamic M Query for user interaction to allow them to select parameters dynamically.
But if I use the ODBC connection, the 'Bind to Parameter' option is not available for parameter selection, but only in DirectQuery.
I want to add dynamic parameters through an ODBC connection for a Snowflake stored procedure in Power BI. Please help.

[s2joshi]

Hello,
I can get the data when I use the Snowflake connector to retrieve data from a table or view in Snowflake to Power BI.
However, when I try to retrieve data from a stored procedure using the advanced option in the Snowflake connector, I get the
error 'Assertion failure: unknown_type_unsupported.' This happens when I attempt to call the stored procedure with a SELECT statement.
I have created the stored procedure output in table format in Snowflake, and this SELECT statement works fine in Snowflake.

Please help me call the Snowflake stored procedure with data in Power BI Desktop.

Regards,

Sharad

[amitchandak]

@s2joshi , Dynamic M parameter is only supported for Direct Query for limited sources.

Once we imported Data, we can use field parameters or calculation group based on need

Calculation Groups: https://youtu.be/cyWVzAQF9YU?t=53314

Field parameters: https://youtu.be/cyWVzAQF9YU?t=53967

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw