Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Matrix export as is from POWERBI to Excel

I was trying to export Matrix table data from powerbi to excel, but couldn't do so as desired.

I have three dimension fields in row and one dimension field in column and 3 measures are in values section.

When I exported the matrix into excel I got the data into flattened mode i.e. raw data format but not as pivot format into excel.


I had to recreate pivot again in excel based on exported raw data into excel to get the desired result.

Is there any other way in POWERBI to get this export result directly?


Thanks in Advance,


Status: New

Hi Mehul,


I'm afraid this is how Export data works. Please vote on an idea or create a new one here: allow-table-and-matrix-data-exports-to-match-power and matrix-export-issue.


Best Regards!