Forum Discussion
Duplicate data in Table visualization - Displaying as is Data
Abhaykumar - You could also add an Index column to your query on import so that you have a unique number. Power BI is first and foremost a data aggregation and visualization tool, it sort of assumes you want to DO something with the data, not just display it raw.
That being said, surprisingly, I have not see this posted in Ideas, so I would recommend that you submit it and post the link back here so we can vote for it.
Abhaykumar - You could also add an Index column to your query on import so that you have a unique number. Power BI is first and foremost a data aggregation and visualization tool, it sort of assumes you want to DO something with the data, not just display it raw.
That being said, surprisingly, I have not see this posted in Ideas, so I would recommend that you submit it and post the link back here so we can vote for it.
Thanks Greg_Deckler. I have posted the idea here
Hi Abhaykumar,
I also have reported this issue internally, will keep you update once I get any information.
Thanks for your question.
Best Regards,
Qiuyun YuAny update?
Thanks v-qiuyu-msft, I have also noticed this behavior with the R visual implementation in the default data set that it creates and there is no way to "undo" it other than to have the R script reference the source information and essentially create a new data set. I have posted this in Ideas to allow one to turn off removing duplicates in the default R visual data set that is created or at the very least allow us to create a data set using the same syntax as shown in the comments so that we can at the very least create our new, non-dedupped data set from the data in our data model instead of having to go back to the source.
