Forum Discussion
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 in power bi desktop/services( matrix form). Kindly give some solutions.
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.
2 Replies
- v-yuta-msftCommunity Support
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.
- AnonymousNot applicable
after export in excel use pivot table.
If repeating, use macro or Power Query