Forum Discussion

krishnaveni05's avatar
krishnaveni05
Frequent Visitor
7 years ago
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 in power bi desktop/services( matrix form). Kindly give some solutions.

  • 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.

     

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    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's avatar
    Anonymous
    Not applicable

    after export in excel use pivot table.

    If repeating, use macro or Power Query