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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Arjun_13
New Member

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

3 REPLIES 3
lbendlin
Super User
Super User

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?

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.

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

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.