Forum Discussion
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 ...
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.
: )
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.
: )
Thanks Chris,
Will this do it everytime the data is refreshed automatically in subsequent events?
Regards,
Rebecca
