Power BI Dataset refresh issue(Duplicate Value)

[Sheetalkhare151]

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!

[Idrissshatila · Accepted solution]

Hello @Sheetalkhare151 ,

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

[Sheetalkhare151]

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

[Idrissshatila]

Hello @Sheetalkhare151 ,

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

the table with one side should have distinct values.

[Sheetalkhare151]

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.