OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E and Column contains a duplicate

[Anonymous]

Hello, 

I am facing an issue when refreshing the datasets and am quite lost. The erros i get:

1. Combined reporting data

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

2. Combined planning data

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

3. All Employee date

Column 'GPN ' in Table 'All Employee date' contains a duplicate value 'konsultants' 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.

Regarding problem no. 3: found no duplicates in my table:( Could someone please advice what is possible to do? Happy to provide more info if needed

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

“Regarding problem no. 3: found no duplicates in my table:”

Suppose you establish a 1:* relationship for two tables, then refresh the data and the table on the 1 side will be refreshed to contain duplicate data, then this type of error will occur.

So you need to check your data source. If the two tables in the data source have been updated to *:* relationship, then an error will be reported when you refresh.

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.

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

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.

[Anonymous]

yes, thank you!

[amitchandak]

@Anonymous , refer these solition

https://community.powerbi.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-to/td-p/68775

https://community.powerbi.com/t5/Desktop/Refresh-error-quot-contains-duplicate-value-and-this-is-not/td-p/588890

https://community.powerbi.com/t5/Power-Query/Duplicate-Value/td-p/781471

How to debug error : https://www.youtube.com/watch?v=OE6DPmKqN7s

[Anonymous]

Intereting.. I only one active connection, which is Many to One. It used work fine..

Thank you, @amitchandak. Unfortunately those solution did not help much