5032
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.
STATUS DETAILS
Needs Votes
Ideas Administrator

Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.

Comments

W

Was wondering why this is no longer in the Top ideas? As other have stated how many votes does this need for this to be implemented? We have come from another reporting tool which exports to Excel perfectly - we are bemused why PowerBI could not do this. We have spent hours with the data in excel because of this.

W

This is literally the number one issue with PBI. I can't help but believe, the reason for it's absence is to ensure there are no "work arounds" to ensuring all report viewers are correctly licensed. Sadly, this hurts those that are doing the right thing the most.

W

Salesforce report export options will export a matrix/pivot table report to Excel and keep the formatting. We've been building out more Salesforce reports and exporting them from there.

W

With over 5,000 votes in favor, why is this no longer listed among "Top Ideas"? As Jamie asked on 11/02, how many votes does this need, Microsoft? I'm tired of telling our users that they can't simply copy and paste a matrix into Excel as it appears within PBI. Microsoft, please give us this functionality.

W

This is very important! And we have no ways to fix. Please implement this.

W

I will definitely recommend Qlikview, this is too essential for end users who work with a lot of data

W

Coming from Qlikview this is absolutely a must have function, our team expects not to lose this feature after using it for years on a daily basis. Deal breaker.

W

How many votes does this need?

W

In addition to this please consider our request too for the matrix visual in power BI which is allow filter conditions on Columns field in the matrix visual.

Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=64f4fe06-de11-eb11-8441-0003ff52809c

W

BI Helper Matrix is a Chrome extension to export matrix and table visuals in Power BI to Excel. Retains visual formatting and matrix data pivots. Works with all tables and 2 x 2 (row x column) matrix drill-downs.

https://bihelper.tech/bihelper_matrix.html