Loading data from Microsoft SQL Server or Azure SQL databases to Qlik Sense fails at one or more specific fields. Upon excluding these fields, the reload works normally.
Error message shown in the data load progress dialog and document log is "Incorrect syntax near keyword <fieldname>"
(sometime just "Connector reply error ***
" without any further details), although Qlik Sense script editor does not prompt for any syntax error.
The issue is only observed when a number of specific words, such as "Function" or "References", are used as field names in the database.
Words like "Function", "References" are reserved keywords for Microsoft SQL Server or Azure SQL databases, which cannot be used directly as object names in SQL queries.
A complete list of reserved keywords for for Microsoft SQL Server or Azure SQL can be found at https://msdn.microsoft.com/en-us/library/ms189822.aspx
Tables/ columns named with reserved key words should be quoted with double quotes or square brackets in order for the containing SQL query to work.