Forum Discussion

SagarB's avatar
SagarB
Frequent Visitor
2 years ago
Solved

Stored procedures with parameters in a Direct Query connection

How to get data from a SQL-server by using stored procedures with parameters in a Direct Query connection? Facing Error (Microsoft SQL: Incorrect syntax near the keyword 'EXEC')  I've tried using P...
Need Help
  • VijayP's avatar
    VijayP
    2 years ago

    SagarB 

    CREATE VIEW MyView AS
    SELECT * FROM MyTable WHERE Column1 = 'Value1';

    or use Query Folding by adding extra steps in using M Language

    #"Filtered Rows" = Table.SelectRows(Sales, each [SaleDate] >= #date(2023, 1, 1) and [SaleDate] <= #date(2023, 12, 31))

VijayP's avatar
VijayP
Community Champion
2 years ago

SagarB  Oh! I missed that , DirectQuery mode in Power BI does not support the execution of stored procedures directly. Instead, create a view or a table-valued function in the database and query this object in Power BI

SagarB's avatar
SagarB
Frequent Visitor
2 years ago

VijayP  Thank you. I have one question: for view can we pass parameters?