Table doesn't display duplicate lines

Hi, Anonymous 

I think you should understand that Power BI removes duplicate rows from a table by default. This is due to Power BI being an aggregation tool. The only way to display duplicate lines in your table chart is to make them different in at least one field. Therefore, adding a column is unavoidable. If you think that it will lead to the user being confused when exporting the data. You can just add an index column in the Power Query editor to give them a unique ID, like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.