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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

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.