Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.