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

Juha-Pekka Niittymaa on 14 Oct 2021 13:55:46

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

This is the most needed update for our organization, where will it arrive??

WALTER's profile image Profile Picture

Vivekananth Nadar on 14 Oct 2021 08:47:43

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

We were expecting this functionality in the October 2021 Update

WALTER's profile image Profile Picture

Magnus Jönsson on 13 Oct 2021 17:13:23

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

I thought this feature Woolf be a part of the October release bit I cannot find it. Any updates on Wien tis will be available?

WALTER's profile image Profile Picture

Thomas Lacey on 11 Oct 2021 18:09:53

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

would be great feature. Many in our company would benefit to have the download appear as in the matrix. Please roll this out thanks

WALTER's profile image Profile Picture

Sheeja T P on 11 Oct 2021 15:40:30

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

This feature will be very useful if it is structured same as in the Matrix visuals, also directly copy and paste from Matrix visuals to Excel .

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

Merged Idea (1)