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
1 Comment
- v-jiascu-msft
Microsoft 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