Forum Discussion

SaliyaWeera's avatar
SaliyaWeera
Frequent Visitor
3 years ago

call Stored procedures in SQL Server database from Power BI Desktop

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 ...
Need Help
CNENFRNL's avatar
CNENFRNL
Community Champion
3 years ago
= 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.