Forum Discussion
Still duplicates after removing duplicates
Community SupportHi terrells,
From your description, it seems that you are trying to remove duplicate columns in Query Editor, right?
When you click the "Remove Duplicates", which columns do you select. If you only select column "Public Folder Path" then click the "Remove Duplicates", it will remove duplicates in column "Public Folder Path". While if you select column "Public Folder Path" and other columns then click "Remove Duplicates", it will delete duplicate rows when this column "Public Folder Path" and other selected columns have the same values. For more information, see: https://support.office.com/en-us/article/Remove-duplicates-Power-Query-d9cffc69-dc5d-4d94-8b66-72779688874d
In your scenario, I would suggest you go to Query Editor, select column "Public Folder Path" then click "Remove Duplicates" then apply the change to see if the issue is gone.
By the way, please run the latest Power BI desktop.
Best Regards,
Qiuyun Yu
Hi
"In your scenario, I would suggest you go to Query Editor, select column "Public Folder Path" then click "Remove Duplicates" then apply the change to see if the issue is gone. "
This is exactly what I have done before posting the issue, and therefore the reason why I posted the issue i.e. removing the duplicates by the above method does not remove all the duplicates, and as mentioned in the opening post, power bi seems to be aware that there are still duplicates despite 'removing' them via query editor, as the counts at the bottom of the page when you select the public folder column displays the rows and distinct values.
But thanks anyway.
- v-qiuyu-msft
Hi terrells,
Please go to Query Editor, check if Remove Duplicates for the column "Public Folder Path" is the last step.
Does the issue happens to this one specific report or all reports?
Which Power BI desktop version do you run? Could you try the latest one.
Best Regards,
Qiuyun YuHi
Yes it is the last step, not tried it on any other report so far but not had any problems in the past.
Current version is Nov 2017 but I will update to Dec 2017 version as soon as available for download and retry.
Thanks
Stuart