Executing SP in Power BI

[Anonymous]

Hi All,

I'm trying to create parameter and execute my SP in Power BI.

While initially loading the data the EXEC command ran correctly and data was loaded, but after creating the parameters and updating the query I'm getting the below error while performing Close and Apply.

Please let me know what is wrong in this?

P.S : While doing all these actions with Import data mode everything is working fine but I'm getting the error while using Direct Query mode.

Updated Query:

Parameters Created:

Error:

Regards,

Himanshu

[amitchandak]

@Anonymous , please check the syntax

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/