Remove duplicates using powerbi by each source.name

[Anonymous]

Hello everyone 🙂

Does anyone here know how do I remove duplicates value for each source name after I've combine the files. But please be mindful, all the data is from a sharepoint folder 

[ChielFaber · Accepted solution]

In the Powerquery UI you can just select the option remove duplicates.

Also see

https://learn.microsoft.com/en-us/power-query/working-with-duplicates