Data Refresh Fails, Error message claims duplicate ID value in table

I have also had this issue when I am pulling data from an API.  I assumed it was tempormentality of the API requests but I am consistently able to manually refresh or refresh in the desktop version whereas the PowerBI scheduled refresh seems to fail very regularly so I am now convinced there is a flaw in the way the cacheing of some queries works.  My primary key is a integer ID column and whilst I don't personally manage the database I know that it is the primary key of an SQL table so it is almost inconceivable that there could be a genuine duplicate.

I am using the staging table suggested by mahidharsridhar below.  Microsoft do need to look into this.