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