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 (820)
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.

WALTER's profile image Profile Picture

Trevor Brown on 04 Aug 2020 21:00:03

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

My Company's users also request the ability to copy and paste table and matrix data from the service dashboard into excel.

WALTER's profile image Profile Picture

Steven B on 31 Jul 2020 19:28:15

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

Absolutely need this feature. Currently all the visually appealing and helpful formatting from tables is destroyed when exporting to excel.

WALTER's profile image Profile Picture

Miranda Tao on 28 Jul 2020 18:06:35

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

Also agree this is a much needed feature. It adds more flexibility to consumers to play around with their own calculations in Excel without needing to mess around in PowerBI.

WALTER's profile image Profile Picture

Gabriele Gneri on 17 Jul 2020 11:44:58

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

Definitely needed! How is it possibile that Microsoft does not develop this request? In many many cases data are to be exported and managed differently and for different purposes: being obliged to say to a customer "you can only look at them, not use as you like" makes Power BI an extremely limited tool!
Also in many cases (like ALL of our reports) the data shown in the matrix are generated by very complicated calculation that are possible to PowerBI but absolutely not possible for tools like Excel if starting from the original dataset.

WALTER's profile image Profile Picture

Udit Kumar Chatterjee on 15 Jul 2020 13:16:59

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

OMG !!! Posted from 2016 and still, it's not available. This would be a great thing to be added as a feature to Power BI

WALTER's profile image Profile Picture

Alessandro Galimberti on 14 Jul 2020 12:58:02

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

Also for me it is a mandatory feature!!!

WALTER's profile image Profile Picture

Jeroen Groothedde on 11 Jul 2020 07:21:26

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

Unfortunately there doesn't seem to be a workaround other than exporting it yourself and creating a matrix in Excel yourself. Very time consuming and it's disappointing that it's only possible by upgrading to Premium and using the paginated reports. Unfortunately third party solutions like Power BI Robots can't do this either.

Come on Microsoft, this would make the quality of life when using Power BI so much better.

Merged Idea (1)