Issue with Removing Duplicates

[Anonymous]

Hello everyone,

Iam facing issue with remove duplicates option.I have 4 tables with X column.I am appending this x column  to one table and I applied the 'Remove duplicates' option.When Iam applying one to many Relation ship this appended table to another table,it shows an error one of the column has unique values.Why it is coming after duplicates were removed??Please help me.

Thanks,

Chunduri

[v-qiuyu-msft]

Hi @Anonymous,

1. Check if this column contains the uppercase and lowercase for the same words: eg: A and a. See: https://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210

2. Also check if there is a blank space at the end of the character, see: http://community.powerbi.com/t5/Issues/Cannot-create-relationship-with-quot-f-quot-and-quot-f-quot-f/idi-p/442123

Best Regards,

Qiuyun Yu

[Anonymous]

Thank you,

Yes, the values have blank spaces at the end of the character.

Regards,

Chunduri