Unable to resolve "'AttributeCollection' contains non-unique item names" error.

[Syndicate_Admin]

Hello,

When attempting to transfer data from a Sharepoint Online List to a Dataverse table, I encountered this error:

Despite trying numerous methods to fix this error, including assigning different primary keys to select for, I still was met with this same screen no matter what. Any advice? Thanks! 

[Syndicate_Admin]

For me the source somehow had two fields differing only in case, i.e  Id and ID. Removing one of these in the PowerQuery interface resolved the problem. 

[Syndicate_Admin]

I am trying to do the same thing and have the same message, I don't see how this answer helps. 

There is no field "AttributeCollection" in either the source or the dataverse table. 

If there is a field validation error, why can't it tell me which field is failing validation. 

[xzmiche · Accepted solution]

from the warning window, the message tells us below information:

1. You Dataverse table set field validation rules

2. The field "AttributeCollection" was set unique

3. You try to upload non-unique items

Proposal: check Sharepoint List field "AttributeCollection" whether it contains duplication items.