Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Dataset refresh issue(Duplicate Value)

Hi, 

I'm getting this error in Power BI service 
Column 'PAR_ROW_ID' in Table 'W_PARTY_ORG_D_Agency' contains a duplicate value '0' 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.

I've verified the database and desktop, and there are no duplicates. I specifically filtered the table for Par_row_id = "0", and it only returns one value. Additionally, I thoroughly reviewed all relationships, and there are no auto-detect issues.

Regarding the incremental refresh, I've implemented it alongside the table join. Could there be a problem with the incremental refresh?

Thanks!

Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello Anonymous ,

     

    you need to check the duplicate from the power query side, because it's bit importing the data with duplication.

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello Anonymous ,

     

    you need to check the duplicate from the power query side, because it's bit importing the data with duplication.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Idrissshatila ,
      I checked the table. I went to the Power Query and removed duplicated values, but I still get the error.

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        2 years ago

        Hello Anonymous ,

         

        then there's still an id that has more than one value, maybe blank.

         

        the table with one side should have distinct values.