Problem updating data - duplicate values

[Syndicate_Admin]

Hello Community,

This is my first post, I come here after trying several days to solve my problem.

The problem is as follows:

I have a problem updating my data, the error I get is :

The "Gpo.art." column in the "Article Group" table contains the duplicate value "001012", and this is not allowed for columns on one side of a many-to-one relationship or for columns that are used as the primary key of a table.

1. I don't have any duplicate values in that table
2.I already checked that my relationships are well set up from 1 to many.

I don't know how to solve it, any idea?

Thanks in advance,
Eb

[V-pazhen-msft · Accepted solution]

@Syndicate_Admin 

The only possibility is you have multiple blank values in the column, power bi also recognizes multiple blanks as duplicated value. 

1. Remove the duplicated blanks if you can.

2. If your model does not let you do that, you can create a bridge table (Distinct table = Distinct(Table[column]). Then connect this table with the original 2 tables.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

It sounds like you do have duplicated data. How did you check that you don't?

If you go to the Data pane and select the column in question, does it give the same number for rows and distinct values?