Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Hello @Sheetalkhare151 ,
you need to check the duplicate from the power query side, because it's bit importing the data with duplication.
Proud to be a Super User! | |
Hello @Sheetalkhare151 ,
you need to check the duplicate from the power query side, because it's bit importing the data with duplication.
Proud to be a Super User! | |
Hi @Idrissshatila ,
I checked the table. I went to the Power Query and removed duplicated values, but I still get the error.
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.
Proud to be a Super User! | |
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.