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 and course year.

I tried "&year","&courseyear I am getting error: Incorrect syntax near '-'. I may have to do some conversion. I don't know how to do.

can you help get this right?

 

Thank You

 

 

 

2 Replies