Export Matrix table data to Excel

[krishnaveni05]

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.

[v-yuta-msft · Accepted solution]

@krishnaveni05,

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.

[Anonymous]

after export in excel use pivot table.

If repeating, use macro or Power Query