Microsoft SQL: Incorrect syntax near ';'. Incorrect syntax near ')'.

[xskiffman]

When I apply query changes, I'm getting the following error. Microsoft SQL: Incorrect syntax near ';'. Incorrect syntax near ')'.

This is the the power BI query I feel is causing the problem [Query=";WITH FinalEntry#(lf)AS#(lf)(#(lf) SELECT [SessionId]#(lf)

[v-lid-msft]

Hi @xskiffman ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @xskiffman ,

Does this query works before? Could you please try to check and change the SQL statement in Advanced Options by click the gear icon near the step which has issue?

Best regards,

[Anonymous]

I'd look at your SQL code and see if thats been updated.  It looks like it starts with ";WITH"  Note the semicolon.

I'm wondering if someone has opened up the SQL code and mistakenly either added the ";" by mistake, or accidently overwritten a block of SQL code prior to the WITH statement.