Excel Export - Data with Current layout option is not available in Desktop Version

Hi melvin9900 ,

Exporting data from a report visual in Power BI Desktop is straightforward. When you export the data, Power BI creates a .csv file with the data.

1. Select the visual, select More options (...) > Export data.
2. In the Save As dialog box, select a location for the .csv file, and edit the file name, if you want.
3. Select Save.

My service version: 13.0.18578.34

• For export from matrix visuals using Data with current layout, consider the following:

  • Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns

  • Matrices with only one row and/or values but no columns will be exported as table (no right border separator)

  • If the Show on rows toggle is set to 'On' in Power BI Desktop for a table or matrix visual, the visual format would not be preserved when data is exported to Excel

  • If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu.

More details: Export the data that was used to create a visualization 

If I have misunderstood your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

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