Skip to main content
Microsoft Idea

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

Marc Ybarsabal on 07 Oct 2021 19:25:49

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

Please make this happen! The consumers of my reports are actual humans and prefer the data to export pivoted!

WALTER's profile image Profile Picture

Hallie Gromek on 07 Oct 2021 12:33:49

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

I believe 2021 release wave 2 went out 9/28. I still don't see how to do this. Can someone show me?
Easier and unlimited deployment of Power BI Embedded multitenant solution

WALTER's profile image Profile Picture

Kevin Taylor on 05 Oct 2021 08:18:14

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

Export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.

Try this workaround:
Remove the dollar or pound sign in Power BI for all values, then just above Visual (Matrix or Table) click ... , select Export data, File format .xlsx (Excel), Export. After export you can do an AutoSum in excel , on all columns.

WALTER's profile image Profile Picture

on 30 Sep 2021 18:47:30

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

Ability to highlight and directly copy and paste from Matrix to Excel would be awesome!

WALTER's profile image Profile Picture

Adam Kent on 30 Sep 2021 04:14:09

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

This would be especially useful if the full table was exported to excel even if not visible on the single PBI screen (i.e. the table has more rows than can be presented on page of the report).
Thanks

WALTER's profile image Profile Picture

Catarina Morgado on 29 Sep 2021 14:23:28

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

Do we know if this will be released in October?

WALTER's profile image Profile Picture

Eshan Pacheriwala on 28 Sep 2021 13:54:56

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

We so need this feature. On top of it a schedule export of those particular tables/data visuals.

WALTER's profile image Profile Picture

Hayden Amess on 24 Sep 2021 12:08:35

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

This feature would be very helpful to our business. Some visualisations are impossible or at very least very time consuming to recreate in excel. It would make life much easier if it were exported as it looks in Power BI.

WALTER's profile image Profile Picture

Vasudev Patil on 22 Sep 2021 05:25:15

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

Its 5 Years old and almost 6K upvotes and still its in "Planned" status.
Its high time needs to be implemented ASAP

WALTER's profile image Profile Picture

Daniel Pantano de Moura on 09 Sep 2021 20:42:50

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

@administrador estamos aguardando essa importante implementação, tem alguma previsão pra nos passar?

Merged Idea (1)