How to display and export raw data correctly in Power BI

[Anonymous]

Hi there, 

I have a question about how to display and export the raw data correctly in Power BI.

I have a sample data as below: 

I need report view to show the same layout as data view and allow the user to export the excel file in the same. 

I used the 'table' visual, but show wrong information. 

Can you please guide me how to do it. thank you.

[lbendlin]

Power BI automatically aggregates/groups.  You need to add a unique row identifier (an index column for example) and include that column in your table visual.