Forum Discussion
How to automatically remove duplicates in PowerBi + Power Query / How to Avoid duplicate errors
Hi! Open Power Query, right click on teh column you want to remove duplicates on, select Remove duplicates. This will add a step to Applied Steps and the de-duplication will happen each time you refresh.
Hi! Open Power Query, right click on teh column you want to remove duplicates on, select Remove duplicates. This will add a step to Applied Steps and the de-duplication will happen each time you refresh.
Hi Audrey, thanks for your reply! The data refreshes automatically mutliple times each day and also when I am out of the office. I hope very much to find a way to remove the duplicates automatically. Manually removing them that way works though - I've just tried it - thanks.
Hi! Doing it this way isn't manual. It is now part of your applied steps in Power Query so each time the data refreshes it will complete that step and do the deduplication. You set it up the one time and that's it.