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.
Please develop this feature.
Nalini G commented
Hi, This is very import features for our customers to export data in matrix format as our traditional reporting tool was supporting this. Can you please let us know as when this will be available in Power BI?
@microsoft - can we get an explanation as to why this will not be worked on and no time timetable? There is sooo much pent up demand for this feature from customers.
You should see the expression of the common user go from this product is awesome to, wait, this won't export in the right format? It is the face you get when you find a hair in your food at a restaurant.
This is number one thing I tell people now to manage their expectation on PBI. They usually go a different route knowing PBI does not have this functionality for end users.
Please, this is really required and have been available in products such as Qlikview for ages...
Please enable this feature as users want to export the data from Visual to Excel in pivot form
Ayub Khan commented
Please enable this option of Matrix Data export to Match PBI, Whereas Other Competitors like Qlikview & Tableau has this beautiful feature which is very much needed.
Needed this feature.
Please develop - greatly needed for the common PBI report user...
Really needed function
Kiran Hosakote commented
BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals
Visual formatting and matrix data pivots retained in Excel download.
Secure Microsoft login - use your Power BI login to access Matrix 4.0.
Free 14 day trial.
I must have had the same conversation 20+ times with different people in my organisation about this one feature. We have tons of matrices. In the real world, like it or not, users will want to export their data to excel.
We've tried the "Yes but do you REALLY need to export it to excel?" method. It doesn't work. They do.
You cannot explain this to a non-technical person and it make an ounce of sense.
"Yeah I know it looks all whacky, but matricies are different from tables you see. You could always try to create a pivot table in Excel... yeah just ask Clippy he'll help you"
3000+ users votes with 3+ years...
Please add the ability to export formatted tables to .xlsx. My organization requires this. We have several custom formatted columns that is lost with download to .csv
I do not understand how after almost 4 years of this request, and with multiple comments and votes it haven't been solved yet. Please watch other tools like tableau, they do that!
Really need this function.
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.