Removing duplicate data

[Rebecca_Hadad]

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

[Anonymous · Accepted solution]

@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]

Thanks Chris,

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

Regards,

Rebecca