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.
Thanks Sean for your reply. This is a work around that I am using right now. However, it is baffling that i cannot display data as is. I wanted to explore if there is any way to turn auto-unduplication off.
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?
