workaround show all rows include duplicates in a table visualisation without adding more columns

HI fittore_709394 ,

This is the way Power BI works in the table visual.  I would guess a couple ways around it would be to put in a "hidden" column.  Maybe a column taht is titled "." or seomthing and then you can hide it.  That way all the variables will show, including the duplicates.

Another trick might be to create an Index Row and hide it.  That may work because now every row (including duplicates) has a unique Index number and should be considered "available"...

If for Exporting purposes, i'd suggest using Paginated Reports. It will preserve duplicates as long as your dataset query does not aggregate and they are fundamentally row-based, not semantic aggregation visuals.

You can use the additional Index column trick with hiding this colunm on visual by tweaking the visuals but table Export will still include the column. 

To force Power BI to display every row (including duplicates), you need to include a column that uniquely identifies each record:

1. Add an Index column in Power Query.

2. Include that column in the table visual.

Example (Power Query):

• Add Column → Index Column

This makes each row unique, so the table visual will show all rows.

If you don’t want users to see the column:

• Keep the index column in the visual

• Reduce its width to almost zero or rename it to something unobtrusive.