Passing parameter from Stored proc

[Anonymous]

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

[Mariusz · Accepted solution]

Hi @Anonymous 

Read this article.

https://reevessmith.wordpress.com/2014/08/19/power-query-and-stored-procedures-with-parameters/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hi ,

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

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