Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Ability to run stored procedure using DirectQuery

    Vote (269) Share
    NickiT's profile image

    NickiT on 02 Mar 2018 22:12:59

    Ability to run stored procedure using direct query

    Comments (33)
    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.

    NickiT's profile image Profile Picture

    Chalaapthy Devarakonda on 15 Sep 2021 16:57:41

    RE: Ability to run stored procedure using DirectQuery

    Waiting for this forever

    NickiT's profile image Profile Picture

    David Scott on 12 Mar 2021 18:02:07

    RE: Ability to run stored procedure using DirectQuery

    Absolutely essential to call sprocs in DirectQuery. How many votes do we need to get this on the road map?

    NickiT's profile image Profile Picture

    Robert Williams on 10 Sep 2020 10:29:15

    RE: Ability to run stored procedure using DirectQuery

    I am feeling the urge to look into Tableau these days. Sick and tired of PowerBI "improvements" being useless stuff that no one really needs, but the important stuff is just washed over.