Dataset refresh failed due to primary key violation

[MonikaSaravanan]

Hi All,

I'm getting this issue please kindly guide me through.

Column 'Email' in Table 'Weekly Engagement Survey (Weeks 1-8)' contains a duplicate value and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

Thank you.

[arvindsingh802 · Accepted solution]

This is because the Email column now have duplicate value this ut is failing to refresh

You can choose below solutions as per your business requirement

Solution 1 (Recommanded) - Remove duplicates from Email column in Power Query window

Solution 2 - Update the relationship to Many to Many

If this post helps, then please consider Accept it as the solution and give it a thumbs up