Problem in changing de data source

[ALEX13]

Hi community, I have the following problem when trying to change de data source of the tables in my power bi report:

It is impossible to apply changes, as I always get the same error message,

When the change is made file by file, no error appears.

Any ideas?

[Greg_Deckler]

Apparently when you changed sources you have duplicate values in your CUPS column whereas you didn't before. So, you need to remove the relationship to get your data to load. You will likely need a new table that has unique CUPS that you can use as a bridge table.

[ALEX13]

Hi Greg, ¿what about the OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. error?

[Greg_Deckler · Accepted solution]

Take a look at this thread:

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/td-p/116683