Power BI

Needs Votes

Allow Table and Matrix Data Exports to Match PowerBI Visual

Vote (4721)

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)

Comments (692)

6ecfdf2b 4e0f-4ae7-ba13-40133a6eab59 on 05 Jul 2020 23:03:39

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

This must be prioritized in the development!

6ecfdf2b 4e0f-4ae7-ba13-40133a6eab59 on 05 Jul 2020 23:03:39

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Could we have an answer from Microsoft on this?

This is a show stopper for Power BI adoption from our end user.

8cd35d20 4c29-4143-b34f-45c8b49d954b on 05 Jul 2020 23:03:14

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Please implement. Thank you!

72872e2e 1d12-4ede-bb2f-e30f83080503 on 05 Jul 2020 23:03:08

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

We just had a business case to use this feature.

Please implement this in the next update :)

407fb206 ca28-43c7-b4f5-b9daf30de98a on 05 Jul 2020 23:03:07

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Please implement this soon. My organisation is extremely shocked and disappointed with the severe lack of this feature!!

5b002cbf 7c74-ea11-a811-000d3a579c39 on 05 Jul 2020 23:02:50

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

when reports from Power BI are exported to Excel, the rows are formatted by alphabetical order and the columns disappear and show as one column only. Users need to use pivot table to reformat the whole report. This is extremely inefficient if users need soft copies of the reports to perform additional analysis or copy to other reports.

e772d7c9 524f-4386-a140-cdccf8e90dd8 on 05 Jul 2020 23:02:50

RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

Will now need to recreate all the reports using Pivot as the download to excel will not render the same visual to Excel( matrix visual) . Our current tool Cognos does render and that's how the users need it.