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

Power BI User on 06 Jul 2020 00:12:44

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

Please. Seriously.

WALTER's profile image Profile Picture

Anantha on 06 Jul 2020 00:12:29

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

Really needed function

WALTER's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:12:21

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

BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals

Go to https://bihelper.tech/bihelper_matrix.html.

Visual formatting and matrix data pivots retained in Excel download.

Secure Microsoft login - use your Power BI login to access Matrix 4.0.

Free 14 day trial.

WALTER's profile image Profile Picture

Tom on 06 Jul 2020 00:12:06

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

I must have had the same conversation 20+ times with different people in my organisation about this one feature. We have tons of matrices. In the real world, like it or not, users will want to export their data to excel.

We've tried the "Yes but do you REALLY need to export it to excel?" method. It doesn't work. They do.

You cannot explain this to a non-technical person and it make an ounce of sense.

"Yeah I know it looks all whacky, but matricies are different from tables you see. You could always try to create a pivot table in Excel... yeah just ask Clippy he'll help you"

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:45

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

3000+ users votes with 3+ years...

WALTER's profile image Profile Picture

Bob on 06 Jul 2020 00:11:32

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

Please add the ability to export formatted tables to .xlsx. My organization requires this. We have several custom formatted columns that is lost with download to .csv

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:29

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

I do not understand how after almost 4 years of this request, and with multiple comments and votes it haven't been solved yet. Please watch other tools like tableau, they do that!

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:26

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

Really need this function.

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:07

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

In our organization all users are used to exporting data in excel so this is MUST needed feature to export the matrix format in excel instead of flatten data.

WALTER's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:10:55

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

Much needed feature. Matrix visual is not useful without the capability of being able to export it in excel as it is.

Merged Idea (1)