Forum Discussion
Stored Procedure
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
Thanks in advance
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
2 Replies
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
SQLSourceThank you. I realised this shortly after posting but didn't get chance to come back and say!
