Forum Discussion
Advocate IIError in displaying data in a table
- Hi PaisleyPrince,This is expected if the duplicate record is identical across all the columns you placed in the table visual.The Data/Table view shows the physical rows in the model, so you see all 251 records.But a Power BI table visual shows the distinct combination of the fields used in the visual. So if two rows are identical across every displayed column, Power BI will show them as one row.To force both duplicate rows to appear, add a unique row identifier to the table, for example an Index column in Power Query:Power Query → Add Column → Index ColumnThen include that Index column in the table visual. If you do not want users to focus on it, you can move it to the end of the table or reduce the column width.Similiar solved thread:
Solved: Power Bi Does not Show Duplicate Rows in the Table - Microsoft Fabric Community🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster. Hi PaisleyPrince ,
This is expected behaviour, not a bug. The Table visual in Power BI implicitly groups by the combination of all fields you drop into it, so two rows that are exactly identical across every column will collapse into a single row. The Data (Table) view shows the raw rows, which is why you see 251 there but 250 in the visual.
What to try:
- In Power Query, add an Index Column (Add Column → Index Column → From 1) to your table, then drag that index field into the Table visual. Each row becomes unique and both duplicates will show. You can hide the column by shrinking its width to zero.
- If you don't want to touch the model, add any existing column that differs between the two "duplicate" rows (a key, timestamp, source row ID, etc.) into the visual.
- Double-check there really is no filter in play — click the visual and open the Filters pane to confirm nothing is applied at visual/page/report level, and check the Selection pane in case a slicer is affecting it.
A couple of quick questions:
- Is the duplicate a true duplicate across every column, or only across the columns you've put in the visual?
- Is this table standalone, or is it related to another table in the model? A many-side relationship can sometimes hide rows too.
Useful links:
Hope that clears it up.
If this got you what you needed, a Kudos and an Accepted Solution mark would be great — it helps others searching for the same thing find the answer quicker.
Resolver IIIHi PaisleyPrince ,
This is expected behaviour, not a bug. The Table visual in Power BI implicitly groups by the combination of all fields you drop into it, so two rows that are exactly identical across every column will collapse into a single row. The Data (Table) view shows the raw rows, which is why you see 251 there but 250 in the visual.
What to try:
- In Power Query, add an Index Column (Add Column → Index Column → From 1) to your table, then drag that index field into the Table visual. Each row becomes unique and both duplicates will show. You can hide the column by shrinking its width to zero.
- If you don't want to touch the model, add any existing column that differs between the two "duplicate" rows (a key, timestamp, source row ID, etc.) into the visual.
- Double-check there really is no filter in play — click the visual and open the Filters pane to confirm nothing is applied at visual/page/report level, and check the Selection pane in case a slicer is affecting it.
A couple of quick questions:
- Is the duplicate a true duplicate across every column, or only across the columns you've put in the visual?
- Is this table standalone, or is it related to another table in the model? A many-side relationship can sometimes hide rows too.
Useful links:
Hope that clears it up.
If this got you what you needed, a Kudos and an Accepted Solution mark would be great — it helps others searching for the same thing find the answer quicker.