Refresh Data and Relationship Error (Duplicates)

[jrfa225]

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

Load was cancelled by an error in loading a previous table.

OLE DB or ODBC error: Object reference not set to an instance of an object..

Column 'Week #' in Table 'Gourley_Lynch' contains a duplicate value '35' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

[v-lionel-msft]

Hi @jrfa225 ,

First delete the table relationship, then refresh the data, and finally recreate the table relationship.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jrfa225 , Check if there any duplicate value coming on the one side of the table in 1-M realtion.

Also refer

https://stackoverflow.com/questions/43748120/get-not-allowed-for-columns-on-the-one-side-of-a-many-t...