Forum Discussion

MonikaSaravanan's avatar
MonikaSaravanan
Frequent Visitor
5 years ago
Solved

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 th...
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    5 years ago

    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

arvindsingh802's avatar
arvindsingh802
Icon for Community Champion rankCommunity Champion
5 years ago

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