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

Hargobind Singh on 05 Jul 2020 23:30:41

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

Much needed feature. Seems like a really basic one. Really shocked that power BI doesn't have it.

WALTER's profile image Profile Picture

Pierre-yves on 05 Jul 2020 23:30:36

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

This feature is much needed. Any plan to implement it in the close future?

WALTER's profile image Profile Picture

sharathp on 05 Jul 2020 23:30:28

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

Can't believe this is not an option yet. We are recreating our reports from Oracle BI to Power BI. It's hard to convince users to move on until they have option to print reports or at least export to excel without loosing all the formatting. Both are options not available right now!!

WALTER's profile image Profile Picture

Tim Stutzman on 05 Jul 2020 23:30:20

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

This really needs to be address. Even if you could export the matrix as visualized to Excel would be a good start. I have so many users complaining about this. Creates a lot of work.

WALTER's profile image Profile Picture

Yannick C. on 05 Jul 2020 23:29:56

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

It's very embaracing to not be able to export as it is under Excel. if we consider the work to rebuild using pivot table, it's massive amount of time.

WALTER's profile image Profile Picture

Yannick C. on 05 Jul 2020 23:29:56

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

Why the status is backlog for a so crucial need?

WALTER's profile image Profile Picture

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

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

This is a serious problem. We need to export into Excel and match the PBI visual. Users are totally confused and frustrated when getting results that don't look like their visual.

WALTER's profile image Profile Picture

Laz on 05 Jul 2020 23:29:48

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

This is a massive blocker too.

I have mentioned previously on other posts in the PBI Community that many organisations still cant grasp the idea of not having an excel spreadsheet and almost always regardless of the solution built in Power BI, the want the ability to export in Excel!

The ability to export in Excel from PBI to match the PBI Visual is a must!

WALTER's profile image Profile Picture

Brett on 05 Jul 2020 23:29:48

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

Agree....this would be huge improvement!

WALTER's profile image Profile Picture

Rob Wiegmans on 05 Jul 2020 23:29:32

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

Agree with everyone else - this is blocking usage of PBI right now with my client

Merged Idea (1)