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

Gautam Sudhakar on 05 Jul 2020 22:53:52

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

Very much required for reporting in other programs like Excel and PPT. Our customers/end-users are not going to be Power BI users. Content needs to be able to be delivered in other mediums. Having the exact format from BI to Excel is essential

WALTER's profile image Profile Picture

Vincent on 05 Jul 2020 22:52:44

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

PowerBi is powerful to sort and to organize a huge amount of the data in a nice table, but it's really a pity not to allow the export into excel by keeping its format.

WALTER's profile image Profile Picture

Therese therese.devine on 05 Jul 2020 22:52:14

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

This is really critical, the data becomes unusable when the matrix is lost. Business users do not only want to see the report online, they want a hard, printable copy!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:59

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

Seriously ! why would one use power BI if they have to do re-work of creating a pivot in excel AGAIN ...

WALTER's profile image Profile Picture

Anonymous on 05 Jul 2020 22:51:58

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

We need the functionality, why would someone redo the work in excel.

WALTER's profile image Profile Picture

Trien on 05 Jul 2020 22:51:47

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

The Matrix View in the Power BI interface is lacking many features that are available in Excel Pivot Tables.(Eg: Repeat data in all rows etc...). Users are unable to use Matrix View data for any further joining and linking to other data sets or tables since they cannot export the data to excel. Oracle BI is already having this feature with full fledged Pivot Table functionality. We hope Microsoft will implement this modification soon!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:56

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

PBI should be serious about our complaints and requests to remain competitive among other mature BI platforms.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:37

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

Very much required for reporting

WALTER's profile image Profile Picture

Jon on 05 Jul 2020 22:49:13

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

This is how Performance Point scorecards worked and it was great. Exporting data formatted, with summarized subtotals and grand totals is a must have!

WALTER's profile image Profile Picture

K V on 05 Jul 2020 22:49:02

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

A definite must for any kind of reporting.

Merged Idea (1)