Call a parameterized query/stored proc and pass in parameters from slicer and filtered values?

[dancarr22]

Hello,

We have an on-prem SQL Server db - use gateway to connect.  We would like to leverage the stored procs we have and dynamics call those based on slicer values - and other filters we have on a report.  Is this possible?  If so, could someone please show an example?

Thanks,

Dan

[Greg_Deckler · Accepted solution]

I'm not sure that feature is out just yet.

[dancarr22]

Thanks @Greg_Deckler and @lbendlin 

So, I guess we continue to use SSRS for now!

[lbendlin]

This is generally not possible. You can consider a Direct Query connection where each user interaction results in a new query to the data source but that requires tables or views at the other end. Maybe you can convert the stored procedure into a view?

If you want to go really crazy you can try to do this via R scripts. But that would limit your visuals options.