When download records from Knack with a selected list of columns, the following error occurs:
itgenclr091
An identifier was expected at position 263.
How can I fix this?
The error is caused by a Microsoft OData library raising an error when a column name is selected (in $select) which does not match the OData specifications. The error also involves the message code itgenstp015, since it is a Microsoft ODataException.
In this case it concerns a column that starts with the following characters: 52w.
A change has been incorporated in both the Knack-driver to avoid such less preferred column names, and in the driver for App Online to rewrite such column names in the OData EDM data model.
For now, please select all columns. A new release which improves the handling of such column names will be taken into production without 1 working day.
A new release has been taken into production. Columns in Knack with names starting with a digit have been renamed.
Please alter your column names in the Power Query download to reflect the new names starting with c or create a new Power Query download using the same URL and table.
This question was automatically closed after at least 2 weeks of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.