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.

Vishnu97's avatar
Vishnu97
New Member
2 years ago

I'm facing issue like I need to load the table which should have 500 rows out of that 300 rows will be duplicated. 

But currently in table visual view, it is pulling only the unique rows which is 200 rows in my case. But i wanted to include all the 500 rows eventhough it have duplicates. can you help me with the ways to fix this ?