User entering value and stored procedure returning data

[siphesihle]

Hi all,

I have a report that is getting its data from a stored procedure and has different parameters. How do i get the user to be able to edit the parameters . at the moment i have to go to data tab to edit parameters, I need this in the reporting view

[Insights]

Did this work for you?  I am getting an error/seems like a bug when setting the parameter list to a query - the selection disappears after closing the "Manage Parameters" menu

[amitchandak]

@siphesihle , user can use the slicer on Dynamic M parameter , supported for direct query

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters