Forum Discussion
SQL Stored Procedure with 2 result sets
I need to create 2 table reports on the page. Backend is SQL Server database which is being accessed via stored procedure due to permissions for data access. Table report one selects 3 columns from ...
Hi Dedmon,
I know how to pull data from SQL proc.
Getting the resultset for the first report on the page is clear, but the second report resultsetthen filters the first resultset (from first report) by using a "like" comparison in SQL as per my procedure example in original post.
both queries are pretty expensive for SQL db.
Thank you,
Can anybody help?
basically I need to run one stored procedure, and get 2 resultsets both of them in a separate table report on the page.
Ex: if I run one stored procedure in SQL Management Studio then I can get 2 resultsets (or even more).
Is there any way to do this in Power Bi?
Thank you,