Forum Discussion
Anonymous
6 years agoNot applicable
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
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.
2 Replies
- MariuszCommunity Champion
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.
- AnonymousNot applicable
Hi ,
I already tried "&Number.To Text(year)
but got error as it cannot convert this "2018-19" to number.