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
Amazed that this basic functionality is not even a backlog item. This is a basic feature expectation from Microsoft.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
2020 and this is still not included? This shouldn't still be in the backlog if MS wants PBI to compete with other similar tools.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
this is terrible - a must have by Power BI ASAP
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Many customers have requested. It is an important issue now, so I want it to be realized as soon as possible.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
YES PLEASE
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Another feature PowerBi desperately needs!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is solved - we've built and launched a Chrome extension called BI Helper Matrix for table and matrix data exports from Power BI. See my post dated Feb 24, 2020.
Go to https://bihelper.tech/bihelper_matrix.html to download and test the solution.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
What is the holdup? This is an incredibly common use case. I'm tired of having to explain that Microsoft doesn't think that exporting data is important. #TableauCanDoIt
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This idea was floated and requested way back in 2016. It's been approx. 4 years with no hope as to when it will be implemented. How can we escalate this issue?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
BI Helper Matrix
BI Helper Matrix is a powerful and easy to use Chrome extension for Matrix and Table data exports from Power BI. You can download your Power BI matrix and table visuals as MS Excel files, with support for full vertical and horizontal scrolling of the visuals.
The Excel file retains your matrix data pivots, so you continue to see your information at the SAME level of detail as in your Power BI report. Download and test BI Helper Matrix at https://bihelper.tech/bihelper_matrix.html.