PBI Table Visual only shows distinct rows. I need to see and export duplicated rows also

[Anonymous]

I have a PBI table. If the table has duplicated rows I can't see them in this visual. When there are duplicated rows, I can only see one row instead of all. This causes problems when I use the count function. As an example let's take the tables below,

Real Data Table

Date	Incident
05/19/23	An accident happened due to a lack of attention
05/19/23	An accident happened due to a lack of attention
05/19/23	Slips and falls

PBI Table Visual

Date	Incident
05/19/23	An accident happened due to a lack of attention
05/19/23	Slips and falls

When I use the count function, it tells me there are 3 incidents. But if I visualize them using the PBI table and export the data, I can only see two incidents like the second table. I need to export the whole data set. Like I can see them in the "Data View" tab. Plz tell me how can I download the whole data set using the export function

[johnt75]

You would need to have a column which uniquely identifies each row. If your dataset doesn't have one already then you could use Power Query to add an index column.

You would need to include this column in the table visual so that each row would be shown rather than combining duplicates, but you could set the width of the column to 0.

[pernellt]

This worked for me - thank you @johnt75 !!