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
The Matrix View in the Power BI interface is lacking many features that are available in Excel Pivot Tables.(Eg: Repeat data in all rows etc...). Users are unable to use Matrix View data for any further joining and linking to other data sets or tables since they cannot export the data to excel. Oracle BI is already having this feature with full fledged Pivot Table functionality. We hope Microsoft will implement this modification soon!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
PBI should be serious about our complaints and requests to remain competitive among other mature BI platforms.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Very much required for reporting
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is how Performance Point scorecards worked and it was great. Exporting data formatted, with summarized subtotals and grand totals is a must have!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
A definite must for any kind of reporting.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
this is a must to have feature. Qlikview does it really well
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Agree.. To eliminate the double process from Power BI with Excel..Time consuming..
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is big issue for our engineering group. It is time consuming & difficult to matrix constantly new data sets and then easily share them.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Yes, agree - why would someone want to repeat the data manipulation in excel after having done that in Power BI.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We need this function! Without this most of our reports on Power BI are useless for the end user when exported.