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 (820)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
How many votes does this need?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
In addition to this please consider our request too for the matrix visual in power BI which is allow filter conditions on Columns field in the matrix visual.
Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=64f4fe06-de11-eb11-8441-0003ff52809c
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
BI Helper Matrix is a Chrome extension to export matrix and table visuals in Power BI to Excel. Retains visual formatting and matrix data pivots. Works with all tables and 2 x 2 (row x column) matrix drill-downs.
https://bihelper.tech/bihelper_matrix.html
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
So ridiculous to have to deal with this still today, knowing there is SSRS since the early 2000's and other BI tools allow this seamlessly
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
The ability to export a matrix visual as it was created is essential to presenting the data in a logical fashion.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
To the people asking for a third party workaround I found BI Helper (bihelper.tech). Search for the Matrix Solution. It's not free tho but with the demo I can tell it's great
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Being able to carry the boards would be great. Not being able to do so transforms this tool into an excellent one, since when exporting the information the data must be worked from scratch.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
(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.)
it is really maddening that they do not realize that this development is for the end users who are the ones who occupy the bi. It is really frustrating to explain that something so logical does not work in power bi, considering that it is also a microsoft program just like excel.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
por favor, necesitamos esto...
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Really needed, people want to export the Matrix overviews and just get something they dont understand or have to use PivotTable in Excel to try and get what they need. Not really customer friendly or "i don't know how excel works"-friendly ;)