Forum Discussion
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 ...
Thank you so much. Will give this a go as soon as possible.
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.
Thanks Lydia, this worked perfectly. Would you have any idea how to just pass a textual value, instead of date. So Text.ToText or similar?
let
SQLSource = (Start_Date as date, End_Date as date, Fund_Name as text) =>
Not sure... is this what you were looking?