Forum Discussion

MRZ's avatar
MRZ
Frequent Visitor
10 years ago
Solved

parameters to SP or Sql query

There is probably a simple answer but after looking all over for an answer and trying various methods, the right code still escapes me.  The scenario is I have a stored procedure that uses two input ...
  • MRZ's avatar
    MRZ
    10 years ago

    Thank you so much. Will give this a go as soon as possible.

  • MRZ's avatar
    MRZ
    10 years ago

    By the way, this work fine. Thanks so much. Now I need to find out how to update the parameters in PowerBI.com so that i can refresh the data as needed. Thanks again.

anakoom's avatar
anakoom
Helper I
9 years ago

I have similar issue let me know if you find any solution

SvenTexas's avatar
SvenTexas
Frequent Visitor
9 years ago

Yeh sorry, no solution found yet on text.totext, ended up coding around it unfortunately.  good luck.

  • AJTindall73's avatar
    AJTindall73
    Advocate I
    9 years ago

    Hi Sven, just dont add the "Text.ToText" part. it's already text.

     

    for example:

     

    let
    SQLSource = (param1 as text, param2 as date) =>
let  
    Source = Sql.Database("MyServer", "MyDatabase", [Query="exec [MyDatabase].[dbo].[myProc] '"& param1 & "','" & Date.ToText(param2)&"'"])
in
    Source
in
    SQLSource

     I hope this helps.

     

    Alan

    • SvenTexas's avatar
      SvenTexas
      Frequent Visitor
      9 years ago

      Thank you Alan - can't believe I missed the obvious!  Thank you for putting the response on, am sure it will help others out too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    Guys, you dont need to use Text.ToText, It is required for only non text values. 

    for example: '"& VariableName & "'

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    Guys, you dont need to use Text.ToText, It is required for only non text values. 

    for example: '"& VariableName & "'

  • Firoj's avatar
    Firoj
    New Member
    8 years ago

    let
    SQLSource = (param1 as text) =>
    let
    Source = Sql.Database("gx-zwesqld038.database.windows.net", "ITXTestInterikea2", [Query="EXEC [ITX].[ExcludedTransactionsReportByTransactionCount] '"& (param1) & "' #(lf)#(lf)"])
    in
    Source
    in
    SQLSource

     

     

    check i tried this and it works

    still looking out for way to pass invoked function as input . Slicer could be an option but it takes Stored values than random and it inputs as dropdown or list.

     

    Regards,

    Firoj 

    [email protected]