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
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 layout
- Summarized data
- Powerpoint
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 columns
- Entire matrix/specific row/column selections
- Column names as edited in the visualization
- Row-first/column-first export for matrix/tables with a large number of rows and columns
- Number formatting such as decimals, prefix/suffix
- Notes and annotations
- and 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
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Definitely a big step forward but it does bring the 150k row limit to the forefront. Specifically, when exporting a matrix with a high number of columns (i.e. where month is in the column and 12 months of data is being exported), the 150k export limit seems to be enforced against the underlying data. The result is that the export may contain rows orders of magnitude below what was expected (only 12,500 lines can be exported in the 12 months example). May not be possible to apply the 150k limit to the final export in the current layout but as is it can often turn a quick pull of a single matrix into multiple time consuming exports.