Forum Discussion
Solved
Export Matrix table data to Excel
Hi, i created 2 dimensional matrix table in powerbi , when i trying to export that to excel , it is exported the raw data. Is it possible to get the excel file in the same format as showing ...
You can first publish your report to power bi service and then click the ellipse on the right-top hand of the matrix/table visual, then select "Summarized data".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
after export in excel use pivot table.
If repeating, use macro or Power Query