Skip to main content

Power BI

Needs Votes

Ability to run stored procedure using DirectQuery

Vote (296) Share
NickiT's profile image

NickiT on 02 Mar 2018 22:12:59

Ability to run stored procedure using direct query

Comments (36)
NickiT's profile image Profile Picture

Mauricio Muriel Agudelo on 31 Oct 2024 19:20:40

RE: Ability to run stored procedure using DirectQuery

Large companies often have many datasets in direct query due to the need to always have up-to-date data for decision making. In some cases, stored procedures can be an important resource to improve query performance.

NickiT's profile image Profile Picture

Jacqueline Marquardt on 29 Aug 2024 16:18:25

RE: Ability to run stored procedure using DirectQuery

I am having the same issue. Come on Microsoft, get this fixed already.

NickiT's profile image Profile Picture

Thomas Xiao on 26 Jun 2024 02:33:49

RE: Ability to run stored procedure using DirectQuery

Absolutely need it. SAS can make a similar thing to this work, I am sure Microsoft can too.

NickiT's profile image Profile Picture

Steven Taub on 22 Mar 2024 11:06:16

RE: Ability to run stored procedure using DirectQuery

100% needed. When data sets are huge, a stored procedure to capture just the info needed is an absolute must.In my opinion this is one of the most important features we need and I don't even understand why Microsoft considers this an afterthought.

NickiT's profile image Profile Picture

Haoqing Cai on 09 Jan 2024 03:01:50

RE: Ability to run stored procedure using DirectQuery

Over 6 years, any hope on this functionality?

NickiT's profile image Profile Picture

Mrinal Bhasker on 18 Aug 2023 19:42:18

RE: Ability to run stored procedure using DirectQuery

Why is this so hard, Microsoft? We need this! Also, no comments from the Power BI team tells you something about how the product roadmap is being managed. Sheesh!!

NickiT's profile image Profile Picture

Margot Kiesskalt on 04 Jan 2023 21:39:51

RE: Ability to run stored procedure using DirectQuery

Also CTE.

NickiT's profile image Profile Picture

Steve H on 17 Jun 2022 15:58:35

RE: Ability to run stored procedure using DirectQuery

This should include using temp tables. If I query something in SSMS and it returns data, it should return data in PowerBI as well.

NickiT's profile image Profile Picture

Wayne Power BI User on 13 Apr 2022 17:49:32

RE: Ability to run stored procedure using DirectQuery

Over 4 years!!!

NickiT's profile image Profile Picture

James Fencil on 07 Dec 2021 14:08:26

RE: Ability to run stored procedure using DirectQuery

Wow three years later! This would make life so much easier.