Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
3 |