Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |