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 (818)
- Merged Idea (1)
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.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Hi,
Please assist in add this function to Power BI Desktop.
It's necessary for end users.
If we need to organize data again , then why do we need Power BI?
Maybe just using excel is fine...
Looking forward to receiving a good news.
Many thanks.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please add this feature soon!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Since PBI is a tool for data consumption, can this function be escalated? I mean, I'm pretty sure no one wants to build an additional paginated report. I absolutely do not.
Most all other BI tools allow this (for good reason). Please, help make our (Developers) life easier.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
please, please, please, please, please include this function!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Definitely need this to be functional for the end user!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Agree! Please fix, very annoying to have to reformat data back to table format for end users.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Probably the most needed feature in Power BI IMO. This would make it so much easier for the end user if they want to play with the data or do analysis. Please fix this!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I need to export data which is based on a primary key. I don't want the key exported, but if I don't include it I get a reduced dataset.
Yes, I can hide it in the visual but it is there on export (The visual is a table and there are too many rows to completely display on a visual - it must be exported). The inability to stop the key column from exporting means that several other editing steps are required before forwarding the data to its final destination.
As a vba programmer, this is such an easy fix. Why is this so difficult to implement after so many years?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Unacceptable that this is not even in the roadmap! I understand trying to push towards analysis in power bi but Microsoft you must understand as long as excel exists users will want reports in excel. Also analyze in excel does not always work for every use case!
Please reconsider for 2020!