David Hartell on 02 Oct 2015 09:15:51
I have a Stored procedure that returns multiple result sets, however at the moment when I execute the SP in Power BI I only get the results from the first select statement.
It would be better to create a query for each result set returned.
- Comments (2)
RE: stored procedure with multiple result sets
It would be nice to enter 1 sql statement and get back the tables needed. If one of the base queries takes a few minutes to run & it's output connect's into other stored procs as input, it would be nice to have this run once, not run once per table / proc that needs it's output.
RE: stored procedure with multiple result sets
We are also facing this problem,anyone would face this same problem if so kindly share your ideas with us.