Forum Discussion

dancarr22's avatar
dancarr22
Icon for Helper V rankHelper V
6 years ago
Solved

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

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

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    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.