Forum Discussion
Stored Procedures in Direct Query mode
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.
Hello naresh202 ,
try looking at this workaround here in this solution https://community.fabric.microsoft.com/t5/Desktop/Calling-SQL-stored-procedure-with-Direct-Query/td-p/224831
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍