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

Jason Campbell on 01 Jun 2021 22:21:06

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

Excel is, by far, the most used app in the world for data analysis. How is that this functionality hasn't been in Power BI since inception? I mean, there are gaps and there are glaring omissions. It's safe to go with common sense on this one.

Can we please get more than a generic backlog status update? This lack of functionality/interoperability has significantly hindered our report migration.

WALTER's profile image Profile Picture

Anders Aano on 25 May 2021 07:05:28

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

Hi, Any updates to this? Release Wave 2 was scheduled from October 2020 to March 2021?

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/#:~:text=The%20Microsoft%20Power%20Platform%20release,Data%20Model%20and%20data%20integration.

WALTER's profile image Profile Picture

Sarah Nasr on 21 May 2021 18:02:56

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

Can't wait for this update ! Please fast track the release of this feature

WALTER's profile image Profile Picture

David Lopez on 07 May 2021 06:42:23

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

This is a CRITICAL Functionality for our Users, to be able to export data in the same format that is visualize in the PBI Report. Specially to Track Sales Trends.
It will be good to now for what Sprint this is planned and estimated date when this will be LIVE.

WALTER's profile image Profile Picture

Paramjit Singla on 05 May 2021 08:01:03

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

We have many reports that have matrix visual and users want to export the data in same format.
We are moving from Tableau to Power BI and this feature is working in Tableau. This feature is really required for to complete the migration.

WALTER's profile image Profile Picture

Sreekanth Vishwamurthy on 28 Apr 2021 17:07:10

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

Can you please provide a timeline for this? Ability to take the data in the same visual form is very important.

WALTER's profile image Profile Picture

Benoit Deberdt on 23 Apr 2021 20:36:01

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

Add this feature as soon as you can.
It will save a lot of time when exporting matrix table to Excel.

WALTER's profile image Profile Picture

Rolly V on 20 Apr 2021 17:56:30

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

Crosstab functionality for the win!

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?

Merged Idea (1)