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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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,

Mehul

Status: New
  • Dashboards
Comments
v-jiascu-msft
Employee

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!

Dale