Duplicate rows in table in Power BI

[Analitika]

Hello,

I have a table which contains rows which are duplicated. I tried select a table and remove rows which are duplicates but after this step,

no effect, still see table with duplicated rows, how I could resolve this issue.

I checked that values matches but somehow it treats as duplicated rows.

[v-zhangti]

Hi, @Analitika 

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @Analitika 

Step 1 - Select the Single Column, Run TRIM then remove duplicate
Step 2 - Check Column Profile and Column Quantity in Power Query editor
Step 3 - Load Data from Power Query or power bi Desktop and Select the Column, check status No of Rows, No of Distict Count
If not resolved please share Dataset or pbix file

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[amitchandak]

@Analitika , I doubt there is come value is not same. select the required columns and try again

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.