Duplicate Key value in "one to one" relationship tables

[annae]

Hello everyone!

I have two tables with a "one to one" relationship on relationship view. For only one instance, the column with the unique keys (that concatenates a code and a date) appears twice on data view. This is because a similar entry has been made at the same day.

Is there any way I can except this particular duplication? Because, otherwise, I change the relationship from "one to one"  to "many to many" and all the RELATED() statements between the table's columns have errors.

[v-juanli-msft]

Hi @annae 

If your table1 has duplicate key value, then you can change the relationship to "many to one".

As tested, if you create a column "related(table2[column])" from table2(one side) in table1(many side), it works.

Or you can add index column in both table to keep "one to one" relationship as AllisonKennedy suggested.

Best Regards

Maggie

[AllisonKennedy]

You could add an index or count to make these values unique or if the data is truly duplicate you could add a remove duplicates step in the Power Query Editor to fix the relationship.

[amitchandak]

@annae , You can create a step in data transformation to delete duplicate row based on row or column data

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data