Apply Query changes : Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax

[lavdeepk]

Hi,

I am trying to load from SQL server to power bi model data successfully loaded but when I click on  Apply Query changes and close than I am getting below error refer below screenshot 

Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax

If there is syntax in SQL Query. Why data loaded in the power query data model ??

Please helps

[Anonymous]

Hi @lavdeepk ,
HYG - 
https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/td-p/40983

If any additional clarification required, please let me know.

Best Regards,
Mail2inba4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.