Display tabular data as is without aggregation

[#1]

Table visualization should have an option to display data as is without aggregation even if there are duplicates. There are scenarios where this is required and it would be great to have this option for users.

[Naru]

As per my requirement also i need as it is data.We have option called Keep duplicate but it is not working properly. So i will also recommend to implement feature

[davidc2]

any update on this? we simply want to display the table data as what is returned on the query.

[hemanadezhda]

Team any update on this. Can we now display duplicate rows also in table visualization of power BI?

[fred1]

Tabular data is critical in certain organizations. The ability to see the data as is, without any modifications is important for such things as check registers or purchase orders. Sometimes, there are two items on the same PO, for example, that have the same cost. Currently, the only way to make multiple items with the same values appear is to add a column like a description (not always unique, either) or add an index column in a query, and then put that index into the table, which is meaningless clutter or noise for the report reader.

[stokercw]

Agree. Not only that but case sensitivity is quite important. Why would Power Query be sensitive to upper/lower case values while Power BI Desktop is not? It should not assume to aggregate data on column values that are actually different because of case sensitivity

[swapnil_crapmai]

A Related request: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33644911-paginated-grid-and-hidden-column If implementing duplicate row is not possible, then there should be option to add a column and make it hidden (rather than suggested resize option)

[kcurtis]

I just ran into the same issue and am really hoping for a solution soon; I have situations where I have to display the duplicate rows and having additional "index" columns for the end users to have to look at is not ideal.

[androidtemplar]

This is utterly crazy. If we have a list of employees and there are 2 named Sharon Jones, other one of them will be hidden, unless there is a unique-value column (employee_id etc.) in the table visualization. Power BI should visualize data, not alter it !!! This is horrible. 😞

[stsnbk_harashim]

I also faced the same problem. In the bar graph, it is displayed that there are 11 data. However, since I want to know the details of the data, when I select a table by visualization, only ten data are displayed. Data of the same content was summarized. This result confuses me, so I expect improvement.

[cunha_rodolpho]

It's been years since this was discovered... no deal, apparently.