Forum Discussion
Duplicate Value
I tried to delete duplicated in the Power Query, but still got the same error when refreshing.
Finally I have deleted the row in the database as a workaround and that let me refresh now.
Thanks!
Hi. I think I remember two times this happend to me with different cases. The first one was having null or blank values that won't let you create the relationship and will show you like duplicates. The second one is in case the column is a text column. If you have text column first modify the column to upper o lower case before removing duplicates to be sure you are not having values like "a35728" that won't remove if you have another like "A35728".
Hope any of those helps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Absolutely great tip about the lowercase/uppercase thing. I would have assumed that "remove duplicates" would match match "abc123" and "ABC123", but it doesn't. Once I added a "trasnform to uppercase" before my "remove duplicates", I could then create the 1-to-many relationship I wanted.