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-t...
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.

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Idrissshatila ,

      I've resolved the issue by modifying the initial filter.

      Initially, the filter was set as "Table.SelectRows(W_PARTY_ORG_D1, each [CREATED_ON_DT] >= RangeStart and [CREATED_ON_DT] <= RangeEnd)".

      I've made a change to the filter, now it reads  "Table.SelectRows(W_PARTY_ORG_D1, each [CREATED_ON_DT] >= RangeStart and [CREATED_ON_DT] < RangeEnd)".

      And the Modified filter worked for me.