WALTER on 12 Jul 2016 18:08:52
I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
This would be especially helpful for ongoing forecasting activities.
Administrator on 13 May 2023 12:04:57
Feature has been released in public preview.
- Comments (821)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We have a lot of unhappy power bi users in the organisation that were eagerly waiting for this update for a very long time. It is disappointing this was not part of the October 20210 release. We would like some insight if this is ever happening? And when?
Thanks
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is the most needed update for our organization, where will it arrive??
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We were expecting this functionality in the October 2021 Update
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I thought this feature Woolf be a part of the October release bit I cannot find it. Any updates on Wien tis will be available?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
would be great feature. Many in our company would benefit to have the download appear as in the matrix. Please roll this out thanks
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This feature will be very useful if it is structured same as in the Matrix visuals, also directly copy and paste from Matrix visuals to Excel .
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please make this happen! The consumers of my reports are actual humans and prefer the data to export pivoted!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I believe 2021 release wave 2 went out 9/28. I still don't see how to do this. Can someone show me?
Easier and unlimited deployment of Power BI Embedded multitenant solution
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
Try this workaround:
Remove the dollar or pound sign in Power BI for all values, then just above Visual (Matrix or Table) click ... , select Export data, File format .xlsx (Excel), Export. After export you can do an AutoSum in excel , on all columns.