Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.