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

Power BI User on 05 Jul 2020 23:05:57

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

'+1

WALTER's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:05:46

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

Exporting to excel is the only way we can print a large set of data from Power BI. The fact that it does not keep the same format means that for users who lack excel skills they cannot print their data in an appropriate format.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:38

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

Just about to begin implementation of Power BI but if this feature isn't available it doesn't make sense for us to use Power BI

WALTER's profile image Profile Picture

Leslie Ditsa on 05 Jul 2020 23:05:37

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

Very important feature for me!!!!!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:04:40

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

This is a deal breaker for my company in the adoption of Power BI

WALTER's profile image Profile Picture

Yolanda on 05 Jul 2020 23:04:15

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

Super important for us as well.

WALTER's profile image Profile Picture

DaveG on 05 Jul 2020 23:04:11

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

Critical functionality for adoption in my company and many others.

Many BI Platforms have this basic feature. PowerBI's current export to excel feature is misleading. User's (especially corporate execs) do not have time or expertise to manually recreate a matrix view they see in a Power BI report within Excel for a presentation or to do some quick ad-hoc calculations. Just give the option to extract the current view. Thank you.

WALTER's profile image Profile Picture

Carrie on 05 Jul 2020 23:03:52

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

This is crucial to continue adoption for business users. Unfortunately in
my scenario the data cannot be converted in excel to a pivot table since the data is text and can't be set to the one of the options: average, min....

WALTER's profile image Profile Picture

Subramanian Annamalai on 05 Jul 2020 23:03:47

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

we need this option as this is very useful to all.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:03:45

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

this feature would be very powerful for our sales/marketing people to manage pricing

Merged Idea (1)