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

Power BI User on 05 Jul 2020 23:16:08

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

will be very usefull

WALTER's profile image Profile Picture

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

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

I would be pleased if the export simply had the columns and rows as displayed in a matrix. More than that would be icing.

WALTER's profile image Profile Picture

Meiqiong Zheng on 05 Jul 2020 23:16:03

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

ur BI users desperately need to be able to export the same visual in Power BI

WALTER's profile image Profile Picture

Andrew on 05 Jul 2020 23:15:59

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

Our BI users desperately need to be able to export EXACTLY what is showing on the reports to xls.
As after completing months of development of SSIS/SSAS/Reports and finally completing data validation!
We are now getting user approval/signoff, and this issue (non-functionality) will prevent Production Signoff.
So another month of Oracle, OBIEE instead of MS Power BI.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:15:58

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

Super users want to develop the reports on there own and also need to export the data as is. We are waiting for this feature to move further. Microsoft should introduce this as soon as possible.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:15:54

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

business community desperately needs to be able to export EXACTLY what they see on the reports when export to xls. after 6 months of development of SSIS/SSAS model and much data validation of a suite of reports we are facing no-go issues due to export to xls non-functionality as we are moving from OBIEE to MS PBI .

WALTER's profile image Profile Picture

AM on 05 Jul 2020 23:15:43

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

This lack of a basic feature is preventing this from being a useful tool for our sales force and service teams. PBI can give some nice visuals but the lack of an exportable matrix prevents this from being a serious contender with a business requiring sales data analysis and sharing of information.

WALTER's profile image Profile Picture

Arturo Castillo on 05 Jul 2020 23:15:42

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

We need this function. I share data that needs later formula. Its a waste of time to generate a new Pivot Table in excel to match the Matrix.

WALTER's profile image Profile Picture

Geoff Fawcett on 05 Jul 2020 23:15:17

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

“Export to Excel is the third most common button in data and business intelligence apps after OK and Cancel.”
https://powerpivotpro.com/2012/03/the-3rd-most-common-button-in-data-apps-is/

WALTER's profile image Profile Picture

mnm on 05 Jul 2020 23:15:04

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

To all the previous points, this is one thing that your competitors have but you don't...

Merged Idea (1)