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 (817)
- Merged Idea (1)
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
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
"Feature has been released in public preview."How do I use it????
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
You can export to excel when using Inforiver and the exact same formatting that you see in Power BI is retained. This includes Order of columnsEntire matrix/specific row/column selectionsColumn names as edited in the visualizationRow-first/column-first export for matrix/tables with a large number of rows and columnsNumber formatting such as decimals, prefix/suffixNotes and annotationsand more.Check out this video for more details.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
It is a very useful feautre but it should let users to select using this Preview Feature as default or not.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
The export works for "simple" table (thanks for that) however it still needs to be improved: Mixed up columns and hierachies confuse the result. It would be great to have the columns in the same order.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
need to have this in desktop version