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

adrian marano on 04 Nov 2021 22:12:52

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

Any update ?

WALTER's profile image Profile Picture

Michael Tucker on 04 Nov 2021 18:42:36

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

I find it quite bizarre that other tools have excellent export to excel functionality...and the BI tool from Microsoft fails miserably at it. Please make this happen!

WALTER's profile image Profile Picture

Stephen Madden on 04 Nov 2021 00:37:49

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

Still waiting for this basic functionality that other BI platforms allow. Have been following this thread for a long time now.

WALTER's profile image Profile Picture

Shanawaz Sheriff on 03 Nov 2021 07:45:55

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

Any update on this feature, please? This was planned for Oct 2021 (https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improvements-table-matrix-visuals) and we have been waiting. This is a feature that has been requested by customers over and again.

WALTER's profile image Profile Picture

Catarina Morgado on 02 Nov 2021 14:51:52

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

Any update on this feature release for public preview?

WALTER's profile image Profile Picture

Amit Chakraborty on 28 Oct 2021 15:53:35

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

We are trying to migrate from Tableau to Power BI. Due to the lack of this feature, we are not able to completely convert to Power BI. I cant ask user to export form Power BI to Excel and reformat data, add sub-total and compare it to Power BI again, for each and every time. Defeats the purpose of having Power BI on the first place.
How come this small feature is not available is beyond belief!

Come one Microsoft, do something about it! Don't force people on how to use the product. Give us the flexibility to move our data from Power BI to Excel easily. This feature is really required for to complete the migration.

In 2021, asking for this feature is like asking for Ctrl+C and Ctrl+V, if you know what I mean.

WALTER's profile image Profile Picture

adrian marano on 27 Oct 2021 17:46:13

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

October public preview. ?????

WALTER's profile image Profile Picture

James Ryan on 27 Oct 2021 09:45:20

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

Hi Microsoft, any update on this at all?

The status page for this still shows that it's in Public Preview as of October 2021 however this is not the case!

Any information would be greatly received!!

WALTER's profile image Profile Picture

Mike Yeaton on 26 Oct 2021 21:38:22

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

Any update on timing? This feature will be transformational for our users.

WALTER's profile image Profile Picture

SARAVANAN R on 21 Oct 2021 08:21:50

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

Any update on this feature in next month

Merged Idea (1)