pass a selected value from slicer to SQL server stored procedure

[kumaravel23]

Dear Team,

i am able to run defult parameter to sql server store procedure. i facing issue in if i bind a parameter value to slicer value. the store procedure query not working.  

[fg= my input paramter]

let
data=Text.Combine({"'",fg,"'"}),
Source = Sql.Database("192.168.1.183","kumaravel",[Query="exec CHECK_WO "&fg&""])
in
Source

i need your help team.     

 it is possible?

[kumaravel23]

Hii @lbendlin ,

             thanks for your reply. i will workout your sollution .

[lbendlin · Accepted solution]

You need to do more than that. Your bound parameter can be a single value or a list and you need to construct your custom query accordingly.

Similar to this Chris Webb's BI Blog: Handling Multi-select In Power BI Dynamic M Parameters (crossjoin.co.uk)