Forum Discussion
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
- amitchandakSuper User
NABANITA , You can export summarize data, not the same format as of now.
Please vote or create a new idea https://ideas.powerbi.com/ideas/
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
- Jihwan_KimSuper User
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-mstfCommunity 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-mstfCommunity 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.