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 (821)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please develop - greatly needed for the common PBI report user...
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please. Seriously.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Really needed function
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals
Go to https://bihelper.tech/bihelper_matrix.html.
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.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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"
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
3000+ users votes with 3+ years...
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Really need this function.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
In our organization all users are used to exporting data in excel so this is MUST needed feature to export the matrix format in excel instead of flatten data.