Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |