SSRS report to Power BI - Stored Procedure

[shoaibmaroof]

I want to link a stored procedure to a Power BI report. Initially it was built as an SSRS report. It has 2 parameters (month and year) and a return parameter. 

DECLARE @return_value INT;

EXEC @return_value = [dbo].[sales] @month = '',
@year = '';
SELECT 'Return Value' = @return_value;

This is the advanced editor on Power BI (below). I have made 2 parameters in Power BI. How can I pass these in ...

let
Source = Sql.Database("example", "sales", [Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] @month = '',#(lf) @year = '';#(lf)SELECT 'Return Value' = @return_value;", HierarchicalNavigation=true])
in
Source

my attempt (that doesn't work)

let
Source = Sql.Database("example", "sales", [Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] "&month = '',#(lf) @&year = '';#(lf)SELECT 'Return Value' = @return_value;", HierarchicalNavigation=true])
in
Source

[v-chuncz-msft · Accepted solution]

@shoaibmaroof,

You may change it as follows.

Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] @month = '" & Text.From(month) & "',#(lf)@year = '" & Text.From(year) & "';#(lf)SELECT 'Return Value' = @return_value;"