Forum Discussion

Rebecca_Hadad's avatar
Rebecca_Hadad
Regular Visitor
8 years ago
Solved

Removing duplicate data

Hello,

 

Is it possible to remove duplicate data upon import/refresh of data uploads into a Power BI report?

Based on one column and indiscriminate of hich duplicates to delete.

 

Want to avoid doing this manually each time.

 

Thanks,

Rebecca

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Rebecca_Hadad

    Open up Query Editor. (Home tab of Ribbon... Show Queries button)

     

    Click the column that has the duplicates you want to remove. 

     

    Right click.

     

    Remove Duplicates.

     

    Close and apply.

     

    : )

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Rebecca_Hadad

    Open up Query Editor. (Home tab of Ribbon... Show Queries button)

     

    Click the column that has the duplicates you want to remove. 

     

    Right click.

     

    Remove Duplicates.

     

    Close and apply.

     

    : )

    • Rebecca_Hadad's avatar
      Rebecca_Hadad
      Regular Visitor
      8 years ago

      Thanks Chris,

       

      Will this do it everytime the data is refreshed automatically in subsequent events?

       

      Regards,

      Rebecca