Remove Duplicates Comparison in PowerBI vs Excel

[Syndicate_Admin]

Greetings to all. I have a slight problem and I don't know how to fix it. The issue is that when I perform "remove duplicates" in a table in excel I find a value of 5300 rows, but when I do it in powerbi they are only 5000. I do not understand what the difference is being that in both I perform the action "remove duplicates" in a particular column and I should give myself the same number of rows in both programs.

[amitchandak · Accepted solution]

@Syndicate_Admin , Please are you remove duplicates on a column or a table. Table.Distinct should not have any column name as an argument

When select a column by mistake in power query , it can to remove duplicate for a column