topic Re: Prevent Power BI to remove duplicated rows when exporting to R custom visual in Developer

Prevent Power BI to remove duplicated rows when exporting to R custom visual

Anonymous — Sun, 08 Aug 2021 09:26:57 GMT

Hello,

I'm doing some R custom visuals in PowerBI with the help of pbiviz. I encounter a problem: when Power BI sends the data to the R script, it removes the duplicated rows. How to prevent that? Of course I could add an "id" column 1, 2, 3, ... but this is not convenient because the user would have to select this column whereas it is not used for the visual.

Re: Prevent Power BI to remove duplicated rows when exporting to R custom visual

Greg_Deckler — Sun, 08 Aug 2021 15:50:04 GMT

@Anonymous I have never found a way to do that other than adding an Index column but that has its limits. I even submitted an Idea for it: Microsoft Idea · "R" Don't remove duplicates (powerbi.com)

It is currently "under review".

Re: Prevent Power BI to remove duplicated rows when exporting to R custom visual

Anonymous — Wed, 11 Aug 2021 01:39:06 GMT

HI @Anonymous,

AFAIK, the aggregate is a basic part of power bi visual features. When you use data table records to design charts, Power bi will try to summarize records based on specific categories and groups, you can't prevent these operations on charts. If you are working with table visual, you can configure it to use each field as the category to keeping duplicated records.
For other scenarios, I also think adding a unique field(e.g. index) to expand records should be a better choice.
Regards,

Xiaoxin Sheng

Re: Prevent Power BI to remove duplicated rows when exporting to R custom visual

Anonymous — Sat, 14 Aug 2021 07:52:28 GMT

Thanks @Greg_Deckler . I upvoted your idea.