Share via

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.
14,494 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 120.2K Reputation points MVP
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.