Forum Discussion

terrells's avatar
terrells
Regular Visitor
8 years ago

Still duplicates after removing duplicates

After removing duplicates there are still some duplicates remaining. The Table summary at the bottom of the table knows that there are duplicates as it says TABLE: Dimension_PF (63,036 rows) COLUMN: ...
Data Modeling
terrells's avatar
terrells
Regular Visitor
8 years ago

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's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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 Yu

  • terrells's avatar
    terrells
    Regular Visitor
    8 years ago

    Hi

     

    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