Not load duplicates

[sabeensp]

Hi,

I have a table with customer IDs and other columns, I need to load the customer table, but at the time of loading/refresh  I do not want to load duplicates. Is there a way?

Thanks

[Anonymous]

In Power Query (click the Edit Queries button), right-click the field with duplicate values and choose Remove Duplicates.

[sabeensp]

@Anonymousis it posible not to load duplicates at all, because I have 1 to many relationship between tables. 

[Anonymous]

What type of data source are you using?