Calling a sproc using Incremental Refresh in PBI - MS SQL: Incorrect syntax near the keyword 'Exec'

Hi TahmidBari,

I think these t-SQL statements should be added into the data connector steps instead of navigation step. You can parameterized it with your query parameters.

let
Source = Sql.Database("server_name", "db_name", [Query="Exec rpt_TestSproc "& RangeStart&", "& RangeEnd ])
in
Source 

BTW, which connection mode are you worked? AFAIK, the 'Stored Procedure' not able used in the SQL statement when you are design report with direct query mode.

Regards,

Xiaoxin Sheng