Power BI Desktop (June 2020) - Can't load the data for the Table visual

[Anonymous]

Feedback Type:
Frown (Error)

Timestamp:
2020-06-15T19:35:37.2971212Z

Local Time:
2020-06-15T15:35:37.2971212-04:00

Session ID:
37b4d26a-b3e7-44e7-a6d3-03f30e5a1195

Release:
June 2020

Product Version:
2.82.5858.641 (20.06) (x64)

Error Message:
Incorrect syntax near the keyword 'GROUP'.. The exception was raised by the IDbCommand interface.

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
38.2 GB

Private Memory:
613 MB

Peak Working Set:
760 MB

IE Version:
11.836.18362.0

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
False

Model Default Mode:
DirectQuery

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_inlineExplore
PBI_modelViewASLiveConnect

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_v3ModelsPreview
PBI_relativeTimeSlicer
PBI_dataSearchCuration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-chuncz-msft]

@Anonymous 

Similar issue has been reported: CRI 186364096.

The error occurs because the query used by the customer contains comments (--) in the query. If the query were to run as-is then the query would return results successfully. While using visuals additional query is added around the original query. The '--' comments would extend to the end of line thus breaking the  query generated by the visual.

I would recommend the customer to remove the '--' comments from the query. If that is not possible, they should use Block Comment instead (/* */).

[Anonymous]

Thank you, @v-chuncz-msft! I tried it without the -- and it was still not working. But the next day it started working again. But will keep in mind if it happens again.