Skip to main content
Microsoft Idea

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

    Jaydev on 05 Jul 2020 22:58:50

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

    Please enable this feature. Would be great.

    WALTER's profile image Profile Picture

    Jon Thompson on 05 Jul 2020 22:58:20

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

    Not much help to export CSV and create pivot table. Might as well create in Excel one time.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:57:48

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

    I just want a same display format in Excel as I can see in BI visual matrix so that I can give it to boss.

    WALTER's profile image Profile Picture

    Anon on 05 Jul 2020 22:57:12

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

    Agreed! I'm spending a ton of time recreating a format in Excel that I can see in PowerBI. Quite frustrating haha

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:57:05

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

    It would also be very useful to be able to "Ctrl C" Copy and "Ctrl V" Paste from BI to Excel. That is often quicker than exporting.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:56:43

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

    This would be a very useful feature

    WALTER's profile image Profile Picture

    David Wilson on 05 Jul 2020 22:56:41

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

    I support the request for this option. I need the visualization as shown to be exported (or select All, Copy/Paste). One or multiple screen grabs of the presented visualization does not deliver to requirements.

    WALTER's profile image Profile Picture

    Steve Ward on 05 Jul 2020 22:56:40

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

    Please consider adding this. Possibly easier to implement than many other ideas on there and would be a massive improvement to the product.

    WALTER's profile image Profile Picture

    Ksenija Zegarac on 05 Jul 2020 22:56:40

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

    Please, please add this option. Without that Power BI is almost useless for Self-service BI and/or report sharing.

    We need a comment from Power BI developers on this!

    WALTER's profile image Profile Picture

    Adi K. Asavaid on 05 Jul 2020 22:56:18

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

    This data export feature is absolutely essential. Losing to Qlik, Tableau, etc.

    Merged Idea (1)