Accessing Parameterized Stored Procedure in Power BI Desktop

[Anonymous]

Hi, 

I have accessed paramterized sql server - Stored Procedure in Power BI Desktop.
Now i am trying to assign the slicer selection to the parameter.

When i follow few articals it says i need to select the list - which has the list of values and go to model view -->Properties --> select the parameter under Bind to Paramter. But for me i dont see that option available. i dont see bind to parameter.

Can someone help how to assign the selected slicer value to the sp as input. 

Thanks

[Anonymous]

I am using sql server direct query as a source. i am not finding bind to parameter option.  does power bi supports using paramterized stored procedure and bind that parameter to slicer selection when we use sql server? 
note: i am using direct query 

[Anonymous]

Thank you for the link. I have followed the same link. I have tried both import and direct Query.
i have assigned the list of values to the parameter, when we click edit parameter it works. everytime whenever i change the input parameter using the option available under Transform Data --> Edit parameters the table values are changing based on the input value.
I have a requirement where i need to bind the slicer selection  as input to the stored procedure,

Both direct query and import option i am not getting the highlighted option Bind to Parameter. i am using sql server as a source. Could you please let me know how i can get that option bind to parameter so that i can map the slicer selection to parameter.
Thank you,

[lbendlin]

See here for limitations.  Must have a direct query connection.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn