Forum Discussion

volkanbygl's avatar
volkanbygl
Regular Visitor
8 years ago
Solved

Pass parameters to Adcanced Editor

Hello,   I have a stored procedure which requires three parameters. I am using Import mode, and I can use the stored procedure with fixed parameters like this:  exec SP_MY_STORED_PROCEDURE '2017-1...
  • volkanbygl's avatar
    volkanbygl
    8 years ago

    I found this and it works:

     

    let
Source = Sql.Database("DB_SERVER", "DB_NAME", [Query="exec STORED_PROCEDURE_NAME'"&Date.ToText(Date.From(DateFrom), "yyyy-MM-dd")&"', '"&Date.ToText(Date.From(DateTo), "yyyy-MM-dd")&"' , 62", HierarchicalNavigation=true])
in
Source

    And it works! Thank you guys 

volkanbygl's avatar
volkanbygl
Regular Visitor
8 years ago

I found this and it works:

 

let
Source = Sql.Database("DB_SERVER", "DB_NAME", [Query="exec STORED_PROCEDURE_NAME'"&Date.ToText(Date.From(DateFrom), "yyyy-MM-dd")&"', '"&Date.ToText(Date.From(DateTo), "yyyy-MM-dd")&"' , 62", HierarchicalNavigation=true])
in
Source

And it works! Thank you guys