Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.