Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Anonymous ,

 

Based on your description, you want to get data from sql server by  stored procedure, right?

 

You can achieve by  Advanced Options ,paste the query in the SQL Statement that opened up. CheckNavigate using full hierarchy and click on OK.

 

If you want to pass parameter to stored procedure, please refer to  https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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,