Forum Discussion

Student225's avatar
Student225
New Member
8 years ago

Run SQL Server stored procedure based on parameters

Hi, I am running sql server stored procedure from Power BI and it does bring back the results when I manually set the parameters. However it doesn't work when I define power BI parameters and try...
Student225's avatar
Student225
New Member
8 years ago

Any suggestions.

parry2k's avatar
parry2k
Super User
8 years ago

try this, make changes highlighted below.

 

let
    Source = Sql.Database("SERVER", "DATABASE", 
[Query="#(lf)EXEC#(tab) [dbo].[PROCEDURE]#(lf)#(tab)#(tab)
@COBDate = '" & #"your parameter" &  "',#(lf)#(tab)#(tab)@ValuationRunDefintion = 'Official EoD',#(lf)#(tab)#(tab)@ValuationRunId = 0,#(lf)#(tab)#(tab)@IgnoreZeroVolume = 0#(lf)#(lf)"])
in
    Source