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.
Someone has added this improvement as an idea for Microsoft. I gave it a vote, and I'll leave this here for anyone else experiencing this issue. Option to keep duplicates in Table visual - Microsoft Fabric Community