Allow Table and Matrix Data Exports to Match PowerBI Visual
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.
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.
Extremely shocked and disappointing to see that a functionality like this is still unavailable come 2020.
Agnès COPY commented
This option is absolutely necessary.
We do not use Power BI as a data visualisation only, we should be able to do some Excel exctract in order to share the results with external third parties an allow them to consolidate data from other suppliers/ clients etc ....
Looking forward to have the option available
Lora Davis commented
very disappointing this feature doesn't work yet. Will need to create report in another product in order to use
Won't be able to make the switch from QlikView to Power BI until this one is solved, really need to be able to export a Matrix or a table and maintain its exact formatting, have too many users who need this.
All of our Power BI user complaints go like this...
User: "We want to print the reports but only the first page prints.....then we tried exporting the data and then it looks nothing like the report. How do we send the report?!"
Me: "...….We can go back to Report Builder"
This one is critical. Sad to see it backlogged.
Mike Levi commented
Need this feature. We are dead in the water without it and might need to explore Tableau.
Ekaterina Sukhanova commented
Please allow this feature in Power BI. Very important!!!!
Toby Tarczy commented
Would be great to have this feature for finance
Extremely Important especially for people in Finance. We need the export in a way we see the visuals for upper management and reviews.
Remondo ma commented
Same case as the others, basically i creating an automation with power bi as visualization, the client still need to keep the report file but with as it is matrix visual, i really support this feature to be implemented in upcoming updates
Temos projeto de migrar do QLik view para o Power BI aguardando esse recurso.
It is incredible that, when it comes to two Microsoft applications, this is not implemented. For example, SAP Business Object does this.
Last week I presented a report that would help users to estimate their sales budget for next year, but for creating their budget, they still need to export the matrix to excel, where they find this ugly surprise that the table doesn't keep the original format, so they won't use it.
The idea just died because of a very basic function that should be already implemented.
I agree, this is very disappointing this it not out of the box. I understand theory they want PBI to be an end product and not use excel however they really don't understand how users need to use the data and this results in significant manual work to copy totals. Export should match exactly what the view is or allow an option to choose this. Power of PBI is to get to certain level of data and insights and then it fails when not being able to export that outcome. PBI is not always the end step Microsoft!!! This issue defeats efficiencies that it is meant to promote. Many of our users refuse to use PBI because of this silly issue and want us to implement competitor tools unless this is fixed. It also currently can't do anywhere near as easily or quickly what can be done in excel or with as much control. Until PBI can provide better flexibility and ease of use, people will stay on excel for some aspects of analysis.
Jeff Stafford commented
Export totals please. All numeric data in the visual should be in the Excel/csv output for users to continue to manipulate, especially those with limited Power BI/DAX skills. Currently totals are not exported.
Please, please, please!
Please add this feature, the current behavior doesn't make sense
This is a must have. Microsoft owns Excel, Microsoft owns PowerBI, this integration should be seamless. Microsoft, we need this feature.
URGENT: Microsoft, a lot time has passed already, can we speed up ? some basic functionality that is in QLik view, Qlik sense, and people asking for that after trying to migrate to Power BI.