How to keep all rows (Even they are duplicates) in Power BI

[jq1992powerbi]

Hi, I want to keep all rows from my table. Below is the sample file I use, after loading into power bi from excel, I have 13 rows in total. However, power bi only shows 10 rows (shown below) when I created a table using this data resource. Power BI automatically deleted 3 duplicated rows (same values in all columns)....but I want to keep all 13 rows. I have tried 'Keep Duplicates' in Queries, but doesn't work. Anyone help? Thanks!

[v-chuncz-msft · Accepted solution]

@jq1992powerbi,

You may check the post below.

https://community.powerbi.com/t5/Desktop/Two-rows-show-in-the-src-db-Advanced-Editor-Desktop-tbl-but...

[jq1992powerbi]

Thank you!

"I now understand that Power BI removes duplicate rows from a table by default. This is due to Power BI being a aggragation tool.

The way around this would be to create a index column to provide the uniqueness of rows. "