Power BI

Needs Votes

Ability to run stored procedure using DirectQuery

Vote (298)

NickiT on 02 Mar 2018 22:12:59

Ability to run stored procedure using direct query

Comments (36)

Comments (36)

Chalaapthy Devarakonda on 15 Sep 2021 16:57:41

RE: Ability to run stored procedure using DirectQuery

Waiting for this forever

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?

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.

Robert Williams on 10 Sep 2020 10:27:51

RE: Ability to run stored procedure using DirectQuery

Two years later....... no improvements.
BUT THATS OKAY BECAUSE WE RECENTLY GOT NEW THEMES!!!!!!!!

Such a basic need to be able to simply pull data from a USP. I have absolutely no option available to me in direct query (which my business leaders demand we use) because the code I need to pull from SQL Server has ARITHABORT OFF; SET ANSI_WARNINGS OFF;
I cannot pass this into direct query in PowerBI, and i cannot use it inside a UDF. It HAS to be done via a USP.

I don't see why hundreds or even thousands of users have to waste their time creating a timed job, and a table to dump data into just so we can pull it into PowerBI direct query.