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.

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.

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 & "'