Forum Discussion

Abhaykumar's avatar
Abhaykumar
Microsoft Employee
10 years ago
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 : ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I'm also having this problem.  We are trying to dig into financial details and want to be able to see which payments are duplicated (and thus erroneous), but the Power BI Desktop table doesn't show duplicates, it shows each unique row only.  I get that this is an aggregate tool, but it seems like the table should have a property that allows you to show distinct or show raw.