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

[Anonymous]

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.

[Anonymous]

Thanks @Greg_Deckler . I upvoted your idea.

[Anonymous]

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

[Greg_Deckler · Accepted solution]

@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".