Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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".
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
@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".
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |