Forum Discussion

NABANITA's avatar
NABANITA
New Member
5 years ago
Solved

Export data Matrics to excel

Can I export matrix table with same format from power bi report to excel?

  • Hi NABANITA ,

     

    Refer to the following blog to achieve the results you want: Matrix and Table Download From Power BI


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Hi, NABANITA 

    Instead of exporting the actual visual to EXCEL, try using Analyze in Excel function, in Power BI Desktop.

    In general cases, you can create the pivot table in Excel in whatever style you want by using columns and measures in Power BI. You can copy-paste that pivot table to a new excel sheet if you want.

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support

    Hi NABANITA ,

     

    Refer to the following blog to achieve the results you want: Matrix and Table Download From Power BI


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support

    Hi NABANITA ,

     

    According to the operation steps given in the blog, I successfully exported the matrix in Powerbi to excel. Reference is as follows:


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.