Forum Discussion
Duplicate value error but no duplicate values
Hi LMACAT ,
they are nine digit numbersCheck the data type of the ID column to confirm if it is 'Text'. If the same ID has a different number of spaces at the end, Power Query will recognize them as different values.
Try use 'Text.Trim' function
Hello LMACAT ,
Power query shows the top 1000 rows only, maybe the duplicate is not visible.
and if the error is saying there's duplicate then there should be some sort of duplicate in a certain place.
or maybe the relationship between two tables is 1 to 1 and there's a many in one of them.
Hello @Idrisshatila. Neither is the case. I checked all the records in the table offline and it is not a duplicate, and the relationship to the other table is one-to-many.
LMACAT What do the ID's look like? Remember, A1 and a1 are the same as far as the semantic model are concerned.
Hi Greg_Deckler they are nine digit numbers. I did Remove Rows Duplicates on the ID column and the total number of rows did not change. Yet when I try to create a one-to-many relationship with another table with IDs, the model says it is a many-to-many relationship. I am stumped.
LMACAT Do you have any blanks? If you have evan a single blank value in each table, then the relationship will get forced to many-to-many.
