Forum Discussion
pass a selected value from slicer to SQL server stored procedure
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?
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)
2 Replies
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)
Hii lbendlin ,
thanks for your reply. i will workout your sollution .
