Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |