parameters to SP or Sql query

Hi MRZ,

I made a test to call stored procedure with parameters in Power BI Desktop. You can review the following example to apply it to your scenario.

In SQL Server, I create a procedure named p4test in test database of v-kaxion2015tes\sql2016tabular server.

Create PROC p4test @sdate date,@edate date
AS
BEGIN
SELECT @sdate StartDate, @edate Enddate
END

1. In Query Editor of Power BI Desktop, click "New source"> "SQL Server", enter server name, database name and statement "exec p4test '8/11/2016', '8/12/2016'", click ok.

2. Right click on that query on the left panel and select Advanced Editor, and paste the below code.

let
    SQLSource = (param1 as date, param2 as date) =>
let  
    Source = Sql.Database("v-kaxion2015tes\sql2016tabular", "test", [Query="exec p4test '"& Date.ToText(param1) & "','" & Date.ToText(param2)&"' #(lf)#(lf)#(lf) #(lf)"])
in
    Source
in
    SQLSource

3.Click “Invoke” button and enter parameter values as shown in the following screenshot.

Thanks,
Lydia Zhang