NickiT on 02 Mar 2018 22:12:59
Ability to run stored procedure using direct query
- Comments (35)
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?
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.
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.
RE: Ability to run stored procedure using DirectQuery
We need this functionality. Literally going to make or break our choice of PowerBI or Tableau.
RE: Ability to run stored procedure using DirectQuery
very nessesary
RE: Ability to run stored procedure using DirectQuery
And CTE as well.
RE: Ability to run stored procedure using DirectQuery
This is very basic functionality. Please provide.
RE: Ability to run stored procedure using DirectQuery
Same issue experienced. This works in Report Builder, why not Desktop ? Please we need this functionality.
RE: Ability to run stored procedure using DirectQuery
This is so crucial, we need this functionality.
RE: Ability to run stored procedure using DirectQuery
Having the same issue with running stored procedure using direct query. Several releases later and there is no solution.