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

    David Breneman on 05 Jul 2020 22:44:09

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

    Yes! Please!!!

    WALTER's profile image Profile Picture

    Doug Williamson on 05 Jul 2020 22:44:09

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

    Seems like such a logical extension of the functionality.

    WALTER's profile image Profile Picture

    Prakash on 05 Jul 2020 22:43:48

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

    Please provide it on priority, client may stop using power BI and will trust excel.

    WALTER's profile image Profile Picture

    Dan on 05 Jul 2020 22:42:50

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

    This is definitely a crucial capability as there are a number of times that spontaneous ad-hoc analysis needs to be done with the data and/or to incorporate the data into existing spreadsheet models. It is not practical to have to manipulate the exported .csv data back into the format that you need. Most BI tools already allow for this...

    Thanks

    WALTER's profile image Profile Picture

    Jason on 05 Jul 2020 22:42:05

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

    I have several clients that need this requirement

    WALTER's profile image Profile Picture

    Chuck Dokmo on 05 Jul 2020 22:41:47

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

    YES. YES. YES. Not having this capability is a serious constraint. I need to export large matrices in my visualized format to PDF for sharing via email with external, non-Microsoft users.

    WALTER's profile image Profile Picture

    Stefanie Lopez-Howard on 05 Jul 2020 22:41:30

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

    I need for my executive management team to be able to grab visualizations I create and put them into presentations, documents, and any format. We give information to legislators and constituents. Grab and go is a must-have.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:41:21

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

    This is one the biggest limitations IMO currently. I've had to forego using PBI as a solution because my end users can't simply COPY the table alone and paste into another sheet or email.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:40:42

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

    Yes, a must have and easy for Microsoft to do. Come on guys, this makes no sense.

    WALTER's profile image Profile Picture

    Mitsu Madhani on 05 Jul 2020 22:38:09

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

    This is a must have. Our clients are having to to pivots once the data is exported in excel , which as stated in the comments defeats the purpose .

    Merged Idea (1)