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 27 Jul 2020 18:00:47
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.
- Comments (692)
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!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please fix this... I have drill-through on my matrix, and I want the data exported to match the current level of drill-through... instead of just defaulting too the most drilled in level.
Please make the data export match what is displayed on the visual !!!