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

Question

Hi,I am trying to load from SQL server to power bi model data successfully loaded but when I click on&nbsp;&nbsp;Apply Query changes and close than I am&nbsp;getting below error refer below screenshot&nbsp;&nbsp;Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax&nbsp;If there is&nbsp;syntax in SQL Query. Why data loaded in the power query data model ??&nbsp;Please helps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,HYG -&nbsp;https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/td-p/40983If any additional clarification required, please let me know.Best Regards,Mail2inba4If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

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

1 Reply

Related content

Declaring SQL variables in Notebooks

Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'.

Incorrect turnover total

Microsoft Azure's map can identify incorrect postal codes - where data?

Paginated reports: getting error that parameter not declared though I properly declared it