How to pass slicer values to a stored procedure?

[VIKPOWERBI]

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

[amitchandak]

@VIKPOWERBI , There is a method, But mostly for SQL server. check if that can work for ODBC

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

[VIKPOWERBI]

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.

[v-yiruan-msft]

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

[VIKPOWERBI]

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.