Allow Table and Matrix Data Exports to Match PowerBI Visual
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.
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.
Sanil Maru commented
Much needed feature. Matrix visual is not useful without the capability of being able to export it in excel as it is.
This is the most important issue to be solved in Power BI atm. Hurry up FFS
Liladhar Badgujar commented
Hi Team, when this will be done. I would request you to prioritize this because this something basic when looking at matrix or table visual user expect it to get exported with same formatting, and it's very difficult to convince user that this is something not supported by product. So please please take this on priority, i know it's the hard time but users don't like it that again after exporting data they have to do same steps which they had been doing earlier so it's waste of their time as well and not appealing to users.
Gabriel Rivera commented
Many users ask for this option, please help us to solve this request.
This request is really a MUST for most of us users! Really a big limit for PowerBI.
This would be extremely helpful for my organisation, thanks!
Please add it, this is very needed!
This is a serious limitation which is causing headaches for our customers and support teams. I hope Microsoft escalates this for a solution soon.
Marco Smulders commented
Please don't say it is solved by Chrome extension called BI Helper Matrix. I don't want to use Chrome and i can't ask my clients to use Chrome. MS needs to come with a solution within Power BI Desktop/service.
At present, we have to use other tools to share dashbord data.
We need export matrix data.
Please improve Power BI.
please add this ASAP very dissapointing!
Gábor Kovács commented
It's a shame on Microsoft that not able or not like to realize a basic feature after 4 years of complaints of their customers.
Mahmoud Abdelsalam commented
I agree, This is a basic feature expectation from Microsoft. Otherwise, we have to think about other products
Amazed that this basic functionality is not even a backlog item. This is a basic feature expectation from Microsoft.
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.
this is terrible - a must have by Power BI ASAP
Many customers have requested. It is an important issue now, so I want it to be realized as soon as possible.
Andrew te Groen commented
Another feature PowerBi desperately needs!
Kiran Hosakote commented
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.