Ability to run stored procedure using DirectQuery

[nicki_tinson]

Ability to run stored procedure using direct query

[christian_terha]

very nessesary

[mdepoint]

We need this functionality. Literally going to make or break our choice of PowerBI or Tableau.

[Robert_William3]

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.

[Robert_William3]

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.

[david_scott]

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

[cdevarakonda]

Waiting for this forever

[jfencil1]

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

[Wayne_Gibson]

Over 4 years!!!

[shabina]

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

[dev12]

Also CTE.