Parameter User Interface for Stored Procedures

aakgun 

You are correct, only a current static list of values is accepted, but based on this blog it appears that future functionality to create a dynamic list of values is coming (Under the "Parameter Accepted Values" section.

1) You would have to use slicers (these allow you to filter the visuals)

2) You are correct, only a current static list of values is accepted, but based on this blog it appears that future functionality to create a dynamic list of values is coming (Under the "Parameter Accepted Values" section.

I haven't found a way to dynamically pass parameters into a stored procedure call... There are a couple open threads that are still discussing this.

What purpose do the parameters serve at the moment? Is there a reason you wouldn't expose all the data and allow the end user to use slicers? One of the great advantages of tools like Power BI is that you can throw alot more data at end users and allow them to slice and dice on their own rather than having to restrict to certain criterias due to processing time/amount of info as we do in SSRS reports.