Forum Discussion
Removing Duplicated to create a relationship!!!
kcantor after an hour of thinking about your question I started to smell burning circuitry so I'm going to give my brain a break. But if you could send me your sample data maybe I can do better with something concrete.
keyahorm I'm dying of suspense. What's the word? Did that help you track down the culprit?
This seems to be a common problem for me, I wonder Microsoft choose not to display the non duplicates?
The error "One of the columns must have unique value" is particularly frustrating, especially after you have chosen 'Remove Duplicates' on both columns. I understand there may be technical reasons for this - but from a usage point of view. The error is useless - the computer may as well just beep loudly, would give you same information as the error!
If this is still open, I have found removing duplicates in a workskheet in the source file (usually excel) is easier. Then you can load the table to creat the relationship in Power BI.
