NickiT on 02 Mar 2018 22:12:59
Ability to run stored procedure using direct query
- Comments (33)
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.
RE: Ability to run stored procedure using DirectQuery
I've invested considerable effort into evaluating Power BI and have decided to suspend further work with it until this feature is enabled. I'm a SQL Server database engineer/architect with 20+ years of experience. It's inconceivable that this feature is still not available.
RE: Ability to run stored procedure using DirectQuery
can't believe this doesn't exist still