cancel
Showing results for 
Search instead for 
Did you mean: 

Line comment after direct query causes Incorrect syntax error

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.

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous,

 

I have reported this issue internally: CRI 66886068. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
v-qiuyu-msft
Community Support

Hi @Anonymous,

 

This is by design for PowerBI for now.

 

Best Regards,
Qiuyun Yu