SQL Server Procedure call error in Power BI

[Jackaroe]

I called sql server procedure using direct query 

Data Preview and Query Edit Window is correct

but apply & close (It is not accurate because of Korea.)

microsoft sql server incorrect syntax near

What is the problem? What should I do?

[v-yulgu-msft]

Hi @Jackaroe ,

You may take a look at below similar threads:

Why is DECLARE not supported (Error)?

Calling SQL stored procedure with Direct Query

Best regards,

Yuliana Gu