Export data Matrics to excel

[NABANITA]

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

[v-henryk-mstf]

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.

[v-henryk-mstf · Accepted solution]

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]

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

[amitchandak]

@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