Forum Discussion
Remove duplicates not working.. Can't create relationship
Yes, I double and triple checked. Everything was done the same way as in my example. Must be an error due to such a large data set.
Community ChampionI would report this as an Issue: https://ideas.powerbi.com/forums/360879-issues
Bummer.. Well I just ended up making another table to mirror the first, linked the summary table, and filtered all the ones. it worked, but with this many lines I'd rather have it be more efficient. Thanks for your help Greg_Deckler
v-sihou-msftMicrosoft Employee
Anonymous
As I tested, the relationship can be created properly between two tables in your sample.
Have you get any error when creating relationships? Did you select correct columns?
Regards,
Yes, I double and triple checked. Everything was done the same way as in my example. Must be an error due to such a large data set.
yaelwassAdvocate I
I'm having the same issue but the data set is only around 2000 rows.
Note that there seems to be an inconsisencty in how case sensetivity is handled: the Remove Duplicates feature is case sensetive but the uniquemenss check done when created creating realationshiops between queries is not. To work around this I just format the key column in the query to UPPERCASE. But this is an aside, I'm getting the issue even though cases are the same