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

Evgeny Utkelov on 27 Aug 2020 09:23:52

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

we really need this functionality

WALTER's profile image Profile Picture

Haley Vest on 26 Aug 2020 14:43:57

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

This functionality is available in Tableau & QlikView. You would think this would be easy for Microsoft since they own Excel.

WALTER's profile image Profile Picture

Michael Comer on 25 Aug 2020 17:13:45

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

Please Microsoft.

WALTER's profile image Profile Picture

Leah Schneider on 18 Aug 2020 19:29:26

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

How does the 8th most popular idea still need votes?

WALTER's profile image Profile Picture

Karthick K on 18 Aug 2020 12:46:46

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

Much needed one.

WALTER's profile image Profile Picture

Derek OBrien on 12 Aug 2020 21:24:14

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

All I can say is that I agree with all the other members, plus, Tableau can do it as we speak.

WALTER's profile image Profile Picture

Munir Rodriguez Chehade on 08 Aug 2020 17:29:53

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

This is an absolute must have. In our company were used to this type of functionality with other BI tools, like QlikView.

WALTER's profile image Profile Picture

Bob M on 07 Aug 2020 14:35:24

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

I want to follow up on my comment from yesterday. I've only been working in Power BI a few weeks, but I already see many advantages over our current BI tool that utilizes MDX. We already extensively use Excel's PowerPivot as a front-end to or SQL back-end, so bringing everything under the Microsoft umbrella makes sense to me. Which is why I am so disappointed to find that we can't export a matrix as it appears in PBI into Excel. This is such as fundamental request and NEED that I can't believe it was first proposed here over 4 years ago and still hasn't been incorporated into the product. Our employees shouldn't have to deal with having to further manipulate the underlying data once it's exported to Excel. That's the purpose of Power BI - eliminating the need for them to do that!! Even with all the limitations of our current BI product, it has had this feature for years. Please Microsoft, get this done.

WALTER's profile image Profile Picture

Nathan Krowitz on 06 Aug 2020 20:33:15

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

Please prioritize this feature-- this would make power BI extremely powerful, and save HOURS on a regular basis for developers who have to work around it.

WALTER's profile image Profile Picture

Bob M on 06 Aug 2020 20:24:12

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

Please add this feature as it will be incredibly useful I'm very surprised it's not available as it seems so basic.

Merged Idea (1)