Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
The tables are massive, I just cannot bring all of it and filter after.
How can I pass slicer values to stored procedure and based on user selection it executes?
I am using ODBC
@VIKPOWERBI , There is a method, But mostly for SQL server. check if that can work for ODBC
That works on ODBC but it is not what I need.
I need the data to change based on user input. So for example if he choose to change slicer ID:14 it will load the query to show all rows with ID:14. I want to pass the slicer value to the stored procedure.
Hi @VIKPOWERBI,
You can refer the content in the following links to get it:
How to update M query parameters based on filters and slicers
Use Slicers for Query Parameters in PowerBI
Best Regards
Hello,
I have researched a lot on this issue and it seems there is no way to do what I need to do.
I tried M query parameters before but they don't support ODBC.
The 2nd link looked interesting hack but at the end It seems I can only use it on power BI desktop.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |