Forum Discussion
Solved
How to automatically remove duplicates in PowerBi + Power Query / How to Avoid duplicate errors
I would appreciate your help removing duplicates / avoiding duplicates in data pulled automatically out of Salesforce. I have 4 tables: 1. A table listing closed service tickets with ticket numb...
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.