Forum Discussion

Cuscino's avatar
Cuscino
Frequent Visitor
8 years ago
Solved

Unique column values

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

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

2 Replies

  • jcarville's avatar
    jcarville
    Skilled Sharer

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Check you have no blank lines