Forum Discussion

eferreira's avatar
eferreira
New Member
10 years ago

Use SQL Store Procedure in Power BI

I have created a basic stored procedure without parameters in SQL Server, when I use the store procedure in Power Bi Desktop the return is ok in design but when I click on Save and Close in datasourc...
Baskarved's avatar
Baskarved
Regular Visitor
10 years ago

Small query over here,If we need to pass parameters to the procedure then how can we use this here?Could you share the syntax so that it would be helpful for beginners.

 

Thanks.

space83's avatar
space83
Helper IV
5 years ago

you can use below syntax:

 

EXEC IP_sel_OrderIntakeRS 'Mazlan','2020-11-04','2020-11-04'