Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Passing parameter from Stored proc

Hi, I am trying to pass parameters from stored proc to the PBI report. = Sql.Database("ServerName", "DBname", [Query= "EXEC usp_Contact_time_Report '2018-19' , 1 "])   My parameter name is year a...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ,

    I already tried "&Number.To Text(year)

    but got error as it cannot convert this "2018-19" to number.