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 @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.
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