Forum Discussion
Exporting a matrix visualization layout to Excel
ReyCarter_777 Hi!
In Power BI Service you can export a Matrix using “Data with current layout”, which keeps the hierarchy structure and includes totals/subtotals (if they’re visible/expanded in the visual).
However, Power BI Report Server does not support this export mode — it only allows flat summarized or underlying data exports. So totals like Workshop or grand totals can’t be exported in the same matrix layout.
If you need that layout in Report Server, the best workaround is to use a Paginated Report or recreate the matrix in Excel (Analyze in Excel/PivotTable).
At the moment there’s no announced plan to add “export by layout” to Report Server.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
ReyCarter_777 Hi!
In Power BI Service you can export a Matrix using “Data with current layout”, which keeps the hierarchy structure and includes totals/subtotals (if they’re visible/expanded in the visual).
However, Power BI Report Server does not support this export mode — it only allows flat summarized or underlying data exports. So totals like Workshop or grand totals can’t be exported in the same matrix layout.
If you need that layout in Report Server, the best workaround is to use a Paginated Report or recreate the matrix in Excel (Analyze in Excel/PivotTable).
At the moment there’s no announced plan to add “export by layout” to Report Server.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
It's a pity, it's a very important feature for the business community.