Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
7 years ago

Not load duplicates

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

    • sabeensp's avatar
      sabeensp
      Helper IV
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        What type of data source are you using?