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 ,

 

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.