Skip to main content

Power BI

Completed

Allow Table and Matrix Data Exports to Match PowerBI Visual

Vote (6127) Share
WALTER's profile image

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)
WALTER's profile image Profile Picture

Power BI User 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.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:03:14

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

Please implement. Thank you!

WALTER's profile image Profile Picture

khan150 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 :)

WALTER's profile image Profile Picture

Power BI User 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!!

WALTER's profile image Profile Picture

Durga KELLA 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.

WALTER's profile image Profile Picture

kundan devireddy 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.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:02:41

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

I've got a manager asking me to recreate all my Power BI reports in excel because it lacks this funcionality.

WALTER's profile image Profile Picture

David Wood on 05 Jul 2020 23:02:31

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

I have users who will not entertain Power Bi because it lacks this functionality. Please can this be developed as soon as possible. many thanks.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:02:02

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

A much needed functionality.Agreed 100%

WALTER's profile image Profile Picture

Travis on 05 Jul 2020 23:01:39

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

Agreed, better export options would be huge.

Merged Idea (1)