Exporting PowerBi Data
1) Hover over the report portion to be exported (the main spreadsheet area) and click on the three dots in the upper right of the report.
2) Click export data
3) Data with current layout will export the exact format you see on the screen. Summarized data is the base data behind the table you are viewing.
4) Click export, and the file will download as an excel file.