Non existent error in Append query

[Paul_Christie]

I've created an append query that looks like this



in the query pane. Since I'm using similar syntax and data elsewhere without getting the '49 errors' text I click on the text to take a closer look and I get this



which seems to say there aren't any errors in the errors table. The query returns the 49 rows of data without any sign of any errors so what's happening and how do I get rid of the '49 errors' text that seems itself erroneous.

Regards
Paul

 

[MarcelBeug]

In general this happens when there are no errors in the query, but errors occur when the query results are loaded into the data model.

Examples:

• unique key values in Power Query (case sensitive), that are not unique when loading (case insensitive),
• numbers with fractions in a column with data type Int64.Type (Whole Number),
• etcetera.

 

[Paul_Christie]

Marcel,

Might this include null values that ought to be empty cells in Excel terms?

Regards
Paul

 

[MarcelBeug]

Not by definition, but maybe in this specific context. You could try (in a copy) and filter out nulls to see f that removes the errors.

 

[Paul_Christie]

Marcel,

I've found it. There was a column that had an integer value in it that was really a text value.

Thanks for the pointers.
Regards
Paul