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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

dynamic m query parameters not working for snowflake

dummy_user_name_0-1747258017698.pngdummy_user_name_1-1747258037919.png

I am attempting to pass a dynamic m query parameter to a snowflake direct query (written in native sql) but get the errors posted in the screenshot above. I'm able to pass a non-dynamic parameter to the native sql with no issues and get the correct results. For context this is a very simple select * from a singular table. I've confirmed that the dynamic parameter and target filter column have the same data type. I've also cleared my cache, and disabled the new snowflake connector preview feature. 

I've also checked my snowflake query history and confirmed that the direct queries I'm attempting to send to snowflake are not being received.

Is this a limitation of the Power BI Snowflake connector? Has anyone been able to successfully use dynamic m query parameters in snowflake? I suspect something is not getting translated correctly to snowflake after query folding occurs, but thats just a hunch. Would be great to get some workarounds, as well as identify the root cause of the bug.

Thanks!
-Matt

Status: New
Comments
dummy_user_name
Regular Visitor
I can also provide the logs if needed! Thanks