Issue refreshing data in PowerBI

[vincpagano88]

Hi! I hope someone can help me. I created my first report in PowerBI (I publish KPI figures in my company).

When I created it with Septembre figures all was fine. Now I updated all excel files with October figures but trying to updating data I receive a lot of errors.

If I update one by one the fields on the right most of them do not get any errors but some (the ones creating most of relationship (example based on store name and month) they get this kind of errors

1)Error OLE DB ou ODBC: Exception de HRESULT : 0x80040E4E.

2) Error saying:The “Store name” column of the “Counter wait time” table contains a duplicate value “018 - Avignon”. This is not allowed for columns on one side of a many-to-one relationship or for columns that are used as the primary key of a table.

I hope someone can help me, I am quite new to PowerBI so I am not that good in managing the relationship in the tool and I do not know what could be the issue. Thank you!

[Icey]

Hi @vincpagano88 ,

According to the error message, try to delete the "many-to-one" relationship before applying changes and recreate it after that.

---

2) Error saying:The “Store name” column of the “Counter wait time” table contains a duplicate value “018 - Avignon”. This is not allowed for columns on one side of a many-to-one relationship or for columns that are used as the primary key of a table.

---

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@vincpagano88 , is the column names in the source excel has changed or renamed?

seems like related to that

[vincpagano88]

Not at all. I just added a new column in all the files (fiscal year) but I have not touched the "Store name" and "Month" column name

[vincpagano88]

Forgot to update the errors