Skip to main content
Microsoft Idea

Power BI

Under Review

"R" Don't remove duplicates

Vote (87) Share
Gregory J. Deckler's profile image

Gregory J. Deckler on 21 Apr 2016 00:52:48

Provide the option of not removing duplicates automatically when creating R visualizations or provide the ability to create R datasets using the same syntax as shown in the comments when creating an R visualization

Comments (17)
Gregory J. Deckler's profile image Profile Picture

Andreu fil on 19 Apr 2024 12:38:49

RE: "R" Don't remove duplicates

Good information, thankssehackear.top

Gregory J. Deckler's profile image Profile Picture

Kayden Kiat Hao LIM on 17 Nov 2022 12:14:37

RE: "R" Don't remove duplicates

it has been eons, why is this still under review?

Gregory J. Deckler's profile image Profile Picture

Thomas Bröthaler on 30 Sep 2021 08:29:57

RE: "R" Don't remove duplicates

This is an old post, but still a relevant topic. By now the option to keep duplicates is still not implemented, but would greatly benefit people working with intended duplicated rows without having to add a unique ID (e.g. datasets with lot of categorical values, where duplicates are common). Any update on this topic?

Gregory J. Deckler's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:51

RE: "R" Don't remove duplicates

This seem to be under review for two and a half year now. Any update?

Gregory J. Deckler's profile image Profile Picture

Power BI User on 05 Jul 2020 23:42:32

RE: "R" Don't remove duplicates

yes, it should not be there. The histogram I have created is not proper one.

Gregory J. Deckler's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:11

RE: "R" Don't remove duplicates

Please allow to keep duplicates. They are also part of historical data, need it in our forecasting in power BI

Gregory J. Deckler's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:38

RE: "R" Don't remove duplicates

I strongly agree - I should be possible to turn off remove duplicates as an option.

Gregory J. Deckler's profile image Profile Picture

Renvaldas Mackevicius on 05 Jul 2020 23:32:18

RE: "R" Don't remove duplicates

Please do the same for Python!

Gregory J. Deckler's profile image Profile Picture

Power BI User on 05 Jul 2020 23:19:20

RE: "R" Don't remove duplicates

Microsoft always adds useless features that always are dumb. The very least, for this stupid feature, is to have it disable-possible.

Gregory J. Deckler's profile image Profile Picture

Aaron C on 05 Jul 2020 23:14:24

RE: "R" Don't remove duplicates

The work around for this is the use of an Index column. However, this does not work if the data is coming from different tables!!! I would have to create a new table with a index column for that new table containing the variables of interest. This would defeat the purpose of using a rational data structure and other aspects.