Power BI

Needs Votes

Ability to run stored procedure using DirectQuery

Vote (272)

NickiT on 02 Mar 2018 22:12:59

Ability to run stored procedure using direct query

Comments (33)

Comments (33)

Craig on 05 Jul 2020 23:57:40

RE: Ability to run stored procedure using DirectQuery

We have a multi-tenant scenario. I can't imagine how I'm supposed to manage 50+ versions of the same query for each one.

Come on, MSFT, Crystal Reports has allowed the use of SPs since the '90s, NP. Tableau/Qlik have no issues with this either...hmmmm.

Power BI User on 05 Jul 2020 23:53:43

RE: Ability to run stored procedure using DirectQuery

How does this not work out of the box. Same with the heir slicer it should just be there and work.

Clark J Hyun on 05 Jul 2020 23:53:10

RE: Ability to run stored procedure using DirectQuery

please allow... this

Power BI User on 05 Jul 2020 23:51:21

RE: Ability to run stored procedure using DirectQuery

Our users expect the data to be real time when it's queried - direct query allows that, but isn't allowed to use stored procedures that return data.

Table value functions are an alternative, but for one of our basic scenarios, the data has to be returned from a stored procedure. This really hinders us from using Power BI.

Please include this feature.

Subhrajit Ghosh on 05 Jul 2020 23:50:55

RE: Ability to run stored procedure using DirectQuery

This is the basic requirement that should be available. Please add this feature at the earliest.

Jeff Messer on 05 Jul 2020 23:48:25

RE: Ability to run stored procedure using DirectQuery

This is a crucial feature needed for teams using Power BI Report Server. We have existing stored procs that have been vetted over time that we use in SSRS regularly, and we need to have these available to our Power BI reports.