Forum Discussion
refresh attempt failing due to duplicate value
Hi PBI refresh attempt is failing due to duplicate value, however I have checked the source (ERP) table and there is not a duplicate record , any ideas on what could be the issue? below is the error...
rubayatyasmin
Community Champion
Community ChampionHi, darb
Open Power query and use group by in SKU column and then you will be able to see if there is any duplicated values in your or not. Sometimes there are special characters available in our data that are not printable. So I suggest you perform a trim operation in that column. Then try to refresh.
Also, do not forget to check the data model if any relationship is creating duplicates or not.