Forum Discussion

Markzolotoy's avatar
Markzolotoy
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), ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Markzolotoy 

What kind of connection mode did you try to connect to SQL, import or Direct Query?

I found a post with the smiliar problem like yours, he solved his problem by change connection mode from Direct Query to import.

Here is the post: Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'.

From this  blog:Incorrect syntax in Power BI - but query works fine in SSMS? I found that Power BI Desktop has issues on parsing Queries in Direct Query mode. It always resolves the front end input SQL statement as a derived table so that statements like DECLARE, CTE will cause syntax error.

Please try to connect to SQL by import with this code.

 

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.