topic Parameterize id when connecting to snowflake function in Developer

Parameterize id when connecting to snowflake function

Arjun_13 — Mon, 06 May 2024 04:52:43 GMT

Hi Team,

I am working on an interesting problem wherein i have setup a connection with snowflake function which takes in 2 parameters like this - SELECT * FROM TABLE(SCHEMA.FUNCTION('@ID1_Param','Id2_Param')) which fetched specified columns for these 2 id's only which will be provided in as parameters.
I have also created these 2 parameters in Power BI with text as type and current value provided.

How can i take this to next step wherein these parameters are provided/selected within power bi and hits the snowflake function and fetches the records only for ID1_Param and ID2_Param

Re: Parameterize id when connecting to snowflake function

lbendlin — Mon, 06 May 2024 18:46:34 GMT

wherein these parameters are provided/selected within power bi

Please be more verbose. How? As parameters that can be changed on the service, or as filters impacted by report user interaction?

Re: Parameterize id when connecting to snowflake function

Arjun_13 — Tue, 07 May 2024 06:42:13 GMT

Hi @lbendlin, so basically i need to have 2 parameters in Power BI through which i can input values(or select values through slicers) into my SQL(the function i created) and that in return will fetch only those records from the snowflake environment corresponding to the parameters the user select through slicers. Hope that helps. Let me know if you need any more clarity.

Re: Parameterize id when connecting to snowflake function

lbendlin — Tue, 07 May 2024 11:31:42 GMT

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Only works if you connect to Snowflake in Direct Query mode.