Stored Procedure

[Naverie]

Hi,

I've been following the below link to get a SP into Power BI with parameters and managed to get so far but when invoking I'm getting this error message:

I've looked at the query and can't for the life of me see where this error is. I'm sure it's very obvious so any help would be greatly appreciated.

let
SQLSource = (SiteId as number, Location as text, Retailer as text) =>
let
Source = Sql.Database("NAV17-DR2", "PW-Reports", [Query="EXEC [planning].[Supply and Demand Extra Day - Report Data '" & Number.ToText(SiteId) & "', '" & (Location) & "','" & (Retailer) & "' #(lf)#(lf)#(lf)#(lf)#(lf)#(lf)"])
in
Source
in
SQLSource

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow... 

Thanks in advance

[d_gosbell · Accepted solution]

It looks like you are missing the closing square bracket at the end of your stored procedure name.

eg.

let
SQLSource = (SiteId as number, Location as text, Retailer as text) =>
let
Source = Sql.Database("NAV17-DR2", "PW-Reports", [Query="EXEC [planning].[Supply and Demand Extra Day - Report Data] '" & Number.ToText(SiteId) & "', '" & (Location) & "','" & (Retailer) & "' #(lf)#(lf)#(lf)#(lf)#(lf)#(lf)"])
in
Source
in
SQLSource

[Naverie]

Thank you. I realised this shortly after posting but didn't get chance to come back and say!