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 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?

Need Help

1 Reply

  • 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.