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
See BI Helper Matrix - 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
14 day free trial.
Kiran Hosakote | BI Helper | contact@bihelper.tech
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Can't edit my initial comment.
Need to add: Adding a Report Builder (paginated report) visual is not the solution. Sure, maybe a workaround. I would think that the needs of most companies can be met w/out having to develop the dashboard and a paginated report.
Copy/export the matrix (and formatting) to excel.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Excel is, by far, the most used app in the world for data analysis. How is that this functionality hasn't been in Power BI since inception? I mean, there are gaps and there are glaring omissions. It's safe to go with common sense on this one.
Can we please get more than a generic backlog status update? This lack of functionality/interoperability has significantly hindered our report migration.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Hi, Any updates to this? Release Wave 2 was scheduled from October 2020 to March 2021?
https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/#:~:text=The%20Microsoft%20Power%20Platform%20release,Data%20Model%20and%20data%20integration.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Can't wait for this update ! Please fast track the release of this feature
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is a CRITICAL Functionality for our Users, to be able to export data in the same format that is visualize in the PBI Report. Specially to Track Sales Trends.
It will be good to now for what Sprint this is planned and estimated date when this will be LIVE.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We have many reports that have matrix visual and users want to export the data in same format.
We are moving from Tableau to Power BI and this feature is working in Tableau. This feature is really required for to complete the migration.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Can you please provide a timeline for this? Ability to take the data in the same visual form is very important.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Add this feature as soon as you can.
It will save a lot of time when exporting matrix table to Excel.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Crosstab functionality for the win!