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

Jad Karami on 19 Feb 2021 04:20:49

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

I cant reiterate any further how much of an impact will this functionality help. I sometimes have to jump into other BI tools just to get this done at a quicker speed. This will also help non-developers/administrators such as sales teams rely more on PowerBI once they have the ability to export visualizations as is into their reports especially when they do not have the ability to rebuild the visualizations based on raw data...

WALTER's profile image Profile Picture

Ajit Varsani on 17 Feb 2021 04:16:57

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

Please can this feature be implemented as I need to export data for my own reports.

WALTER's profile image Profile Picture

James Drever on 16 Feb 2021 12:25:33

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

I have no understanding why this clearly deeply needed change hasn't been made. It is such a fundamental weakness, it comes up repeatedly with actual users, please for the love of god implement it.

WALTER's profile image Profile Picture

on 09 Feb 2021 19:54:27

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

I can only speak for myself but not having this feature really degrades using Power BI in general for my purposes. Matter of fact, it's kind of shocking it's not offered.

WALTER's profile image Profile Picture

Glen McGrath on 03 Feb 2021 14:58:20

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

Would be a very useful feature. Lots of users use the export to Excel function

WALTER's profile image Profile Picture

Yonghun Lee on 01 Feb 2021 01:08:47

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

It is needed

WALTER's profile image Profile Picture

Kiran Hosakote on 27 Jan 2021 10:00:57

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

Here's the solution.

BI Helper Matrix - Chrome extension to export matrix and table visuals in Power BI to Excel. Retains visual formatting and matrix data pivots. Works with all tables and 2 x 2 (row x column) matrix drill-downs.

https://bihelper.tech/bihelper_matrix.html

14 day free trial. No payment information required for trial.

Kiran Hosakote | BI Helper

WALTER's profile image Profile Picture

Blair McNeill on 26 Jan 2021 18:46:30

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

I'd also like to express my disappointment that this doesn't exist.

One of my favorite things to do is create a bunch of export tabs because users can't export in whatever drill view they are viewing.

WALTER's profile image Profile Picture

David Thomson on 25 Jan 2021 09:57:32

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

Every other BI tool I have used, Oracle OAC, OBI, Busines Objects etc. all have the option to choose formatted or raw data export. Come on MS, it does not look good when you can't match functionality that has been available for 20+ years in other BI tools.

WALTER's profile image Profile Picture

Camilo Contreras on 20 Jan 2021 15:07:41

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

Una vergüenza que luego de tantos años, esta opción tan básica no haya sido atendida y resuelta

Merged Idea (1)