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 (822)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We have the need to change the background color on select columns in a table and have it export with the data. This provides highlights to specific columns for the end user when working with table data consisting of 100 columns.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
It would be very usefull to be able to export matrices to excel and have the same formatting there. Is there any solution? Will it be possible? Is there an add in for it?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Kindly please have the export to excel with conditional formatting (as seen on visual) enabled.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please have this export to excel option enabled as the visual looks. It would be of great help
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This still is not exporting as my visual looks in PBI due to the switch values to rows toggle is on. Can we get this fixed. Tableau allows you to export as the visual looks and PBI literally says export data as current layout but its like an illusion. Would really appreciate some real functionality.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This still is not exporting as my visual looks in PBI due to the switch values to rows toggle is on. Can we get this fixed. Tableau allows you to export as the visual looks and PBI literally says export data as current layout but its like an illusion. Would really appreciate some real functionality.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Again, where is this feature located if it has been released?I have a matrix with conditional formatting which is great to view online but there is no suitable export from the many options available. None of the following options are helpful.Data with current layoutSummarized dataPDFPowerpoint
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Where do we find (or how do we access) this functionality?If I select “export data” from the Power BI matrix visual to analyse it in Excel, Power BI attempts to export the full raw data, which is too large to export. I just want the summarised data.If I select “show as a table” I can’t find a way to export data (or copy from) the table. Pressing Ctrl A takes me back to the matrix instead of selecting all as the first step of a copy to Excel.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Where can i find this feature?In both PowerBI service and PowerBI desktop i can not find this option, i have been looking in Options > Preview features too.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
doesnt work