call Stored procedures in SQL Server database from Power BI Desktop

[SaliyaWeera]

I wonder someone can explain me how to use stored procedures (SPs) in SQL Server database to create a dataset using Power BI desktop. I use the same database to create a Power BI data model and want to use some of the stored procedures developed by my team earlier to create some tables.

Is it possible to copy and paste those SPs drectly to Power BI query editor?

[CNENFRNL]

= Sql.Database(svr_name, db_name, [Query="EXEC [schema].sp_name"])

if sp returns multiple recordsets, only the first one will be received by PQ.