Forum Discussion

vincpagano88's avatar
vincpagano88
New Member
5 years ago

Issue refreshing data in PowerBI

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!

 

Need Help

4 Replies

    • vincpagano88's avatar
      vincpagano88
      New Member
      5 years ago

      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

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    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.