Forum Discussion

akosiRandy's avatar
akosiRandy
Frequent Visitor
3 years ago
Solved

How can I call a stored procedure in SQL Statement

In Ssrs, we can call a stored procedure with dynamic parameters,   EXEC usp_Client_Day @Start, @End, @MainCLient, @Client, 'CS,COS','NPG'   Quetion? How do you call a stored procedure with dyna...
Need Help
  • akosiRandy's avatar
    akosiRandy
    3 years ago

    Thanks. I guess by default i should just create the data range parameter within sql statement and create the other parameters in powerbi visual.

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
3 years ago
= Value.NativeQuery( Sql.Database("SqlSvr", "db"), "EXEC usp_Client_Day", {@Start, @End, @MainCLient, @Client, "'CS,COS'","'NPG'"} )
akosiRandy's avatar
akosiRandy
Frequent Visitor
3 years ago

Thanks. Do you enter that code in SQL Statement dialog?