Forum Discussion

naresh202's avatar
naresh202
Frequent Visitor
3 years ago
Solved

Stored Procedures in Direct Query mode

Hi all,  Doing a migration project, in the legacy tool there are stored procedure with direct link to the DB, we need to replicate the same/exact process in PBI. can we execute Stored Procedures in...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, naresh202 

 

Yes, you can execute stored procedures in Direct Query mode in Power BI. However, there are some limitations to this functionality. For example, you cannot use stored procedures that return multiple result sets, and you cannot use stored procedures that have output parameters.

 

Please refer to the following links in the hopes of helping you.

DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

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

  • naresh202's avatar
    naresh202
    Frequent Visitor
    2 years ago

    Hi, if you performed this kind of use case, can you please explain in more details.

    because, when i try to execute a simple stored procedure in direct mode, i am getting below error.

     

     Thanks, Naresh