Refresh error owing to duplicates many to one Relationship

[aditya_kamdi]

Hi I have a many to one relationship between pending Sales this year 

and there are 2 records with same Project Stock Id in "Pending Sales This Year" as there are multiple opportunities on the Stock from All Stock. 

My undersatnding of Many to one was there could be multiple records related from "Pending Sales this year" to one of the Records in "All Stock". How is this wrong and any suggestions to fix it 

[Ashish_Mathur]

Hi,

Your contention is correct - in the Pending Sales this Year Table, there can be repetitions in the Project Stock Name column.  What problem are you facing?

[aditya_kamdi · Accepted solution]

Thanks Ashish, 

All Good there was another relationship created in the background that had been automatically created by Power BI which I had not created which was creating all the problems