Capability to use Stored Procedures(SP) in Power BI Direct Query Mode

Anita Rani 0 Reputation points
2023-10-10T13:44:54.6866667+00:00

Hi There,

Wanted to used Store Procedures in Power BI report instead of Views as they are more optimal than Views but not able to call them in Direct Query mode of data connection.

Kindly suggest a way to use them or kindly add my suggestion to enable Store Procedures in Power BI report Direct Query mode.

Thank you

Anita Rani

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,904 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 102.3K Reputation points
    2023-10-10T21:03:40.72+00:00

    I would suggest that your request is better asked in the Power BI forum: https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums.

    1 person found this answer helpful.
    0 comments No comments