Forum Discussion

LMACAT's avatar
LMACAT
Regular Visitor
1 year ago
Solved

Duplicate value error but no duplicate values

I am not able to apply changes to a table in Power Query and am getting an error message that there is a duplicate value in a column in the table that is an ID number, but there are no duplicate valu...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi  LMACAT , 

    they are nine digit numbers

    Check 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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

LMACAT What do the ID's look like? Remember, A1 and a1 are the same as far as the semantic model are concerned.

LMACAT's avatar
LMACAT
Regular Visitor
1 year ago

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.