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 27 Jul 2020 18:00:47
Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.
- Comments (692)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please add the functionality.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
please do it !!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Yep. Please do it!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please please please allow table and matrix data exports that look like the power bi matrix!! we have it in such a nice format but have to do sooooo much work still!!!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
"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."
I couldn't have said this better! I really hopes this gets resolved. I'm trying to migrate a bunch of reports from SSRS into Power BI and I ran into this Power BI export format limitation. IN SSRS, the matrix format is kept when the data is exported.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Very much required for reporting in other programs like Excel and PPT. Our customers/end-users are not going to be Power BI users. Content needs to be able to be delivered in other mediums. Having the exact format from BI to Excel is essential
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
PowerBi is powerful to sort and to organize a huge amount of the data in a nice table, but it's really a pity not to allow the export into excel by keeping its format.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is really critical, the data becomes unusable when the matrix is lost. Business users do not only want to see the report online, they want a hard, printable copy!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Seriously ! why would one use power BI if they have to do re-work of creating a pivot in excel AGAIN ...
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We need the functionality, why would someone redo the work in excel.