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)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is pretty basic, @microsoft! Many "business users" would like an ability to go beyond just the "pretty visual" which would mean exporting to excel. SAP Business Objects very easily provide this as a basic feature and so does few other reporting tools such as Tableau.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Basic functionality that should be there.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
we are evaluating moving from QlikView to PowerBI and this is the biggest detractor right now. QlikView exports the table to Excel exactly as displayed, retaining all the formatting.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We are just rolling out Power Bi company wide to users and this is the most requested feature that they want. Try explaining that Power Bi does not offer this and they immediately jump to the conclusion that Power Bi just wont cut it to be the Analytic tool of choice. Microsoft has to do something about this irrespective of how many votes its gets for that functionality or not
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please! it is a very important request! Data are to be managed, transformed, evaluated, tested, forecasted... making beautiful reports but not to be able to share "usable" data with the management means the refusal of PowerBI !
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
(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.)
This is an absolutely crazy statement from a sales perspective... who do you think approve the deployment of PowerBi within their corporation? The very people that would like this very user friendly feature...
Next thing you know they ask you to switch reporting tool because "there is currently no timetable around doing so"
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Pathetic. Wasting our time waiting for Power Bi Dev Team to action this. Its very odd though that it does not show up in the top 10 anymore with the number of votes. Its like they trying hide it from users. Very disappointing. The reason for us posting these ideas is to make your product a much better one. 5000+ Votes should be more then enough votes to start development on this.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
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.