Does Power BI now Support pulling multiple Datasets from SQL stored procedure.

[princp]

Do you have any Power BI Solution to pull multiple data sets/results coming from SQL Stored Procedure. IF not, any suggestion ?

[amitchandak]

@princp , You can use SQL server proc to get a table using a query. But I think only one at a time

https://community.powerbi.com/t5/Desktop/How-to-call-execute-a-oracle-stored-procedure-from-powerbi/...

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

[princp]

I want to re-iterate my issue: I am using MS SQL Server as a Data source and calling Stored Procedure that generates multiple results however Power BI is showing me only 1st set of results instead of all of them. It could be the limitation of Power BI but I am wondering is any workaround to this limitation?

[nimbiotics]

Did you ever get an answer to this question? If so, could ypu pleae share the solution?

Thanks in advance