Forum Discussion

Naverie's avatar
Naverie
Icon for Helper I rankHelper I
5 years ago
Solved

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...
error
import
Stored Procedure
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

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's avatar
    Naverie
    Icon for Helper I rankHelper I
    5 years ago

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