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

Dominic Clarke on 23 Nov 2021 10:54:02

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

Needs more testing before final release!

I have found for the default hierarchy in the matrix the columns are displayed in the order of the values/columns were "added" to the table rather than the order shown in the matrix. This means I am having to remove values from the table, saving and re-adding in the order I want them shown. a lot of bother especially with the formats on selected columns.

Interestingly if you expand a level then the column order reflects that shown after the additional column showing the next level. Surely if the display order has been evaluated for these levels it can simply be used for the default level.

WALTER's profile image Profile Picture

Karen Lillystone on 22 Nov 2021 15:55:51

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

Yes this is now working - however I agree with a previous comment - the columns are not exported in the order as per the order as the visualisation - which was very confusing. Otherwise was great to see this finally. Thanks!

WALTER's profile image Profile Picture

Mike Yeaton on 19 Nov 2021 20:48:48

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

This is great! It works for me so far in the service, but not on desktop (not listed in preview features). Will it be added to desktop as well? That's where I often do exploratory analysis. Thanks!

WALTER's profile image Profile Picture

Matilde Trevisiol on 18 Nov 2021 09:54:39

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

Thank you for the release. The export works, but can be improved on several aspects:
- if you export a table that contains columns and measures from different tables, the columns are not reported in the same order as in the visualization, but columns from one table are reported first, then there are the columns of the next table, and so on
- if conditional formatting is used for some fields of a table, when exporting the table, a column containing the value of the measure used for conditional formatting is also shown
- the names with which the columns are exported are those of the original table and not those established in the visualization
- if a matrix contains more than one row in the header (for example turnover 2021, turnover 2020, turnover 2019) and has the months as columns, once the table has been exported, the rows of the header are translated and become columns, developing the table horizontally
- If the fields contained in the matrix/table are decimal numbers formatted to have two decimal places, once exported they maintain the formatting of the original column (with many more decimals)
- The colors are not maintained, but this is rightly specified when you do the export.

I hope you find these tips useful for future updates. Thank you.

WALTER's profile image Profile Picture

Kripa Mahalingam on 18 Nov 2021 03:17:18

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

Microsoft Please!! Been waiting for this feature quite long. Can't see it yet. Please make it happen soon

WALTER's profile image Profile Picture

Mykhailo Fliud on 17 Nov 2021 18:33:54

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

I have updated my Power BI to the Version: 2.99.621.0 64-bit (November, 2021)
and the feature is not available into the list of Preview Features under Options menu.
Is there other place where this preview feature can be turned on for my usage?

WALTER's profile image Profile Picture

R B on 17 Nov 2021 14:46:24

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

I spoke with a MS tech today who said she got notification that this feature was coming and that she expected we may see it as soon as this week.

WALTER's profile image Profile Picture

Pravin Upadhyay on 17 Nov 2021 09:32:40

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

i think preview was expected in October itself, what is the update on this?

WALTER's profile image Profile Picture

Adina Anastasescu on 16 Nov 2021 17:56:10

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

We are trying to move a lot of our reporting in Power BI and this is a huge inconvenient. Looking forward for this update release.

WALTER's profile image Profile Picture

Amity Harlan on 16 Nov 2021 15:40:08

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

Would love to see this right away. Please send the update!

Merged Idea (1)