Skip to main content

    Power BI

    Completed

    Allow Table and Matrix Data Exports to Match PowerBI Visual

    Vote (6127) Share
    WALTER's profile image

    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 (820)
    WALTER's profile image Profile Picture

    Veronica Perez on 05 Jul 2020 23:14:51

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Do you have any news for this improvement? A customer is really asking to have the same visualization as matrix display.

    Thanks

    WALTER's profile image Profile Picture

    Yolanda on 05 Jul 2020 23:14:49

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    This has been posted for an year and half but still not under review..is there major technical block?

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:14:37

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual


    This would be really helpful!

    WALTER's profile image Profile Picture

    Roman Kuzmenko on 05 Jul 2020 23:14:34

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    And the colors!! Colors should be the same like in tabular \ matrix

    WALTER's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:14:23

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    One of the biggest problems with exporting the data at the moment is that when you have a drill down or cross tab type report, the data being exported is actually not what you see on screen. It's un-pivoted in the case of a cross tab and down to the lowest level of detail in a drill down. In the case of percentages which are calculated on the fly, it makes it unusable even in a pivot table in excel.

    WALTER's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:13:58

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    YES!

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:13:49

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Please allow Matrix exporting

    WALTER's profile image Profile Picture

    Yolanda on 05 Jul 2020 23:13:24

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Any update on this please?

    WALTER's profile image Profile Picture

    Hannes K on 05 Jul 2020 23:13:07

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    It is always the first questions in my Power BI trainings - if it is possible to copy/paste the underlying data into Excel? So now it is only possible to see them in a table (show data), which is very cool, but it would be great to copy them from this table directly to Excel to do further calculations. CSV export doesn't work very properly with SSAS live connections.

    WALTER's profile image Profile Picture

    Claudia Machado on 05 Jul 2020 23:13:07

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    I manage a report team that provides information toa sales Department (aprox.100 people), at all levels of the hierarchy. They all want dashboards, but also the data in excel to make some analysis of their own. This feature is very important, or we will have in many cases to stick to excel based reports.

    Merged Idea (1)