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

Oscar Arnesson on 20 Apr 2021 14:05:20

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

Planned for release wave 2 2021? That suggests after September 2021. My Group Controller wants to implement QlikSense over Power BI solely due to this missing feature...

WALTER's profile image Profile Picture

Jonathan Boarman on 20 Apr 2021 00:07:19

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

What is the typical timeline for features of this size to go from "feature request in our backlog" to being released?

WALTER's profile image Profile Picture

Robert Hawke on 16 Apr 2021 22:09:30

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

FINALLY! This has been such a pain. And there are so many use cases:

1) To copy visuals to Excel get them ready for a PowerPoint. Maybe I want to delete a column or some rows. Or maybe change the formatting to better highlight the point I need for my presentation.

2) To do some quick ad-hoc calculations or analysis in Excel. Maybe subtracting some numbers from each other, etc. Trying to do this with Measures is close to impossible.

I can't wait for this to finally be released!

WALTER's profile image Profile Picture

Ritesh Singh on 14 Apr 2021 15:43:19

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

Dear Admin.. Any confirmation on the date ??
Please make it urgent, Other small tools have this feature by default and surprising to see MS taking soo long for this basic mandatory feature

WALTER's profile image Profile Picture

Ryan Jabjiniak on 08 Apr 2021 19:42:52

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

Agree with the other comments - this feature has readily been available in competing products like Tableau. Migrating & assimilating users from one BI platform to another is challenging; but it's embarrassing when they are asked to perform MORE tasks simply to get the data to look similar to the matrix visual they want exported.
Please fast track the release of this feature. Thank you in advance!

WALTER's profile image Profile Picture

Jason Campbell on 16 Mar 2021 01:56:58

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

I have to think that the ability to transform data, format it for end users and give them the ability to easily export it to Excel (another Microsoft product) is in the top 3, or maybe 5 use case scenarios.

It's unbelievable that this feature doesn't exist.

No, under no circumstances, will the paginated report visual suffice (May 2021 release). Not even close.

WALTER's profile image Profile Picture

Travis Stephenson on 15 Mar 2021 12:27:44

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

reality is that as awesome as PBI is some folks still need to take things into Excel or other applications to play with the data. We are doing lots and lots of work arounds because we can't just export the data as seen in the matrix into excel or other programs. Please get this enhancement ASAP. It will really help my company get off pivot tables and into PBI.

WALTER's profile image Profile Picture

Richard Valdez on 03 Mar 2021 21:37:41

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

This feature would be huge for me. I have multiple matrix visualizations in PowerBI that are run much faster and more efficiently than in Excel. I don't know what the wait is on this.

WALTER's profile image Profile Picture

Antony John on 02 Mar 2021 04:16:34

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

It is a key feature which is supported in most of the Basic BI tools. It is a major disadvantage for such a powerful tool..

WALTER's profile image Profile Picture

See Ling Wong on 25 Feb 2021 11:03:05

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

Need this. Why the review takes so long?

Merged Idea (1)