Forum Discussion

Impactful Individual

5 years ago

Error loading data

I have the following SQL in my query: declare @AlarmSummaryAlramCount table (summary_description nvarchar(20), summary_cnt int); DECLARE @reportData TABLE( reportID int, userSID varchar(max), ...

Impactful Individual

5 years ago

I used DirectQuery.

Anonymous
Not applicable
5 years ago
Hi Markzolotoy

I found an issue like yours and it show that:

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.

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

Or you can try import connection as well.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.