When I had a (direct) query ending with a line comment it causes the PowerBi to report 'Microsoft SQL: Incorect syntax near ...' error.
SELECT * FROM Customer -- comment
Changing the comment type to block stopped the error from appearing.
SELECT * FROM Customer /* comment */
I consider this behavior as a bug therefore reporting it here.
I have reported this issue internally: CRI 66886068. Will update here once I get any information.
Best Regards,Qiuyun Yu
This is by design for PowerBI for now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.