Forum Discussion
Copy all data from matrix
I have a Matrix in power bi that i would like to be able to copy values from and paste in excel but would like to be able to do it without manually selecting every cell while holding ctrl. Is there a way to select all values from the matrix and copy values?
effertz12 ok, makes sense.
This is actually a planned improvement, scheduled for Public Preview in October 2021.
See the documentation here:
https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improvements-table-matrix-visuals
6 Replies
Hi effertz12
Click on the ellipsis in the upper-right corner of the table/Matrix (...) then select Export Data.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Because i want the data in athe format that its displayed in. I have users that want this data in excel and dont want to have to pivot it out again when they try and use it in excel. I was hoping that you would be able to copy the data and paste it as it but that clearly must not work. Was wondering maybe if there was some way to automate the export and then pivoting in excel as one process.
effertz12 ok, makes sense.
This is actually a planned improvement, scheduled for Public Preview in October 2021.
See the documentation here:
https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improvements-table-matrix-visuals
effertz12
See these links:https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
