Forum Discussion
Solved
Duplicate data in Table visualization - Displaying as is Data
I want ot display a table from SQL server as is in PowerBI Table visualization. However, PowerBI seems to remove the duplicates from the table when charted. Table in Query Editor with duplicates : ...
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.
I can't believe that we are in 2023 and this problem is not solved from 2016.
Power BI is a powerful software and developers till now cant solve a simple issue
What a waste of time surfing the internet to find a solution of a simple problem like this one for hours.