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','Id...
Need Help
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.