Forum Discussion
Dataset refresh failed due to primary key violation
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.
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 windowSolution 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
1 Reply
- arvindsingh802
Community Champion
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 windowSolution 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