cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dancarr22
Resolver I
Resolver I

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

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

Thanks @Greg_Deckler and @lbendlin 

 

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

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Kudoed Authors