Forum Discussion
Duplicate Error
Have you tried reversing the relationship? I had my reverse on me once and received this error. I checked for duplicates and blanks but found neither. I checked the relationship flow and it had reversed quicker than the magnetic poles in a bad science fiction flick.
In the case of a merged set, you may need to change how you join and which rows you keep. keeping all creates duplicates.
This is how I have the relationship -automatically created after the merging. I am not sure I understand what you mean exactly.
Hi RV,
Since you have checked there's no duplicated rows in 'Status' table, please check if there's "Case Sensitive" issue which makes POWER BI DESKTOP evaluate rows as duplicates. Please refer to a related thread below:
http://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210
Regards,
RV,
Did you ever manage to fix this issue? I'm having a similar issue, but it seems to occur randomly. Sometimes I refresh and it throws the error, sometimes it doesn't.
