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

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

WALTER's profile image Profile Picture

Nilima Rodrigues on 13 Jan 2021 01:53:11

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

This is pretty basic, @microsoft! Many "business users" would like an ability to go beyond just the "pretty visual" which would mean exporting to excel. SAP Business Objects very easily provide this as a basic feature and so does few other reporting tools such as Tableau.

WALTER's profile image Profile Picture

Stephen Madden on 23 Dec 2020 05:10:14

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

Basic functionality that should be there.

WALTER's profile image Profile Picture

Robert Hawke on 18 Dec 2020 05:29:19

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

we are evaluating moving from QlikView to PowerBI and this is the biggest detractor right now. QlikView exports the table to Excel exactly as displayed, retaining all the formatting.

WALTER's profile image Profile Picture

Geogie Varughese on 17 Dec 2020 19:56:01

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

We are just rolling out Power Bi company wide to users and this is the most requested feature that they want. Try explaining that Power Bi does not offer this and they immediately jump to the conclusion that Power Bi just wont cut it to be the Analytic tool of choice. Microsoft has to do something about this irrespective of how many votes its gets for that functionality or not

WALTER's profile image Profile Picture

Gabriele Gneri on 15 Dec 2020 12:00:39

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

Please! it is a very important request! Data are to be managed, transformed, evaluated, tested, forecasted... making beautiful reports but not to be able to share "usable" data with the management means the refusal of PowerBI !

WALTER's profile image Profile Picture

Guerman Vladimirov on 04 Dec 2020 17:02:00

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

(Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.)

This is an absolutely crazy statement from a sales perspective... who do you think approve the deployment of PowerBi within their corporation? The very people that would like this very user friendly feature...
Next thing you know they ask you to switch reporting tool because "there is currently no timetable around doing so"

Merged Idea (1)