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