Forum Discussion

anudeep3721's avatar
anudeep3721
New Member
8 years ago
Solved

calling stored procedure using parameter error

Hi.. i'm calling a stored procedure(SQL) in powerbi using direct query it is executed successfully by passing value manually. Now i'm trying to execute the value using parameter option in powerbi , so when i pass the value to powerbi and execute, it throws me an error "DataSource.Error: Microsoft SQL: Error converting data type nvarchar to uniqueidentifier." . Is there any way we can convert it to uniqueidentifier. Any help would be appreciated.

Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    8 years ago

    anudeep3721,

     

    We can use parameter when call store procedure. Smaple query for you reference.

    let
    SQLSource = (param1 as date, param2 as date) =>
let  
    Source = Sql.Database("servername", "databasename", [Query="exec p4test '"& Date.ToText(param1) & "','" & Date.ToText(param2)&"' #(lf)#(lf)#(lf) #(lf)"])
in
    Source
in
    SQLSource

    Regards,

    Charlie Liao

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    anudeep3721 Pass the text and do the conversion of the value in the stored procedure. That would probably be the most straight forward.

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    anudeep3721,

     

    We can use parameter when call store procedure. Smaple query for you reference.

    let
    SQLSource = (param1 as date, param2 as date) =>
let  
    Source = Sql.Database("servername", "databasename", [Query="exec p4test '"& Date.ToText(param1) & "','" & Date.ToText(param2)&"' #(lf)#(lf)#(lf) #(lf)"])
in
    Source
in
    SQLSource

    Regards,

    Charlie Liao