Unique column values

[Cuscino]

Hi

I ve been trying to create a relationship between two/more column

Since I have 12000 raws, I had to eliminate the duplicates in Excel (Product ID Workbook)

I ve checked and doubled cheked and there aren´t any duplictes but I m still having the same messages error in power bi

" You can´t create a relationship between these two colum..."

Could u help me? Could be a bug?

Thanks

[jcarville · Accepted solution]

Have you tried using the Trim function on your column? There may be trailing whitespace that is causing an issue.

[Anonymous]

Check you have no blank lines