Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |