how to export a matrix table visual to excel

Hi Jeanxyz ,

You could to learn about :Export to Excel improvements for table and matrix visuals .

This is a feature that was scheduled to be released in October, but as of now, it's delayed and not yet available.

Business value

As users explore data in Power BI, many want to continue their analysis in Microsoft Excel. This new feature empowers users who might not have access to edit the report, or who might not be familiar with Power BI authoring capabilities, to pull the data into Excel in a format that's familiar to them. Customers can choose to export data directly from a table or matrix visual so that they can continue their analysis and create their own view of the data.

Feature details

Currently, when data is exported from a Power BI table or matrix (service and Desktop), the structure of the visual is lost in the exported CSV or XLSX file. With this new feature, users will be able to export data from a Power BI table or matrix to Excel and maintain the structure of the visual in cross-tab format. This will reduce the time spent on reformatting data (especially hierarchical data) in Excel.

And I will inform you as soon as there is an official update.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien