Forum Discussion

Arjun_13's avatar
Arjun_13
New Member
2 years ago

Parameterize id when connecting to snowflake function

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

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    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?

    • Arjun_13's avatar
      Arjun_13
      New Member
      2 years ago

      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.