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?
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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