Skip to main content
Microsoft Idea

    Power BI

    Completed

    Export Table and Matrix As Is

    Vote (192) Share
    's profile image

    on 11 Oct 2017 15:28:44

    Can the team enhance the table/ matrix export feature to export them as they were formatted in the desktop?

    Format as in row and column headers stay as it is, with the table background color etc. Currently the exported data is raw format.

    Administrator on 17 Oct 2022 18:23:31

    Please check out our updated options for exporting a matrix. The layout is now preserved. Exporting cell color/background formatting still needs to be implemented

    Comments (13)
    's profile image Profile Picture

    Sumit Deshpande on 09 Aug 2022 18:48:37

    RE: Export Table and Matrix As Is

    Was this ever resolved?

    's profile image Profile Picture

    Chandra Vadana Rajamohan on 18 Jan 2022 12:48:37

    RE: Export Table and Matrix As Is

    You can export to excel as is from your power bi report using Inforiver. Check out this video for more details.

    's profile image Profile Picture

    Bob M on 19 Nov 2020 13:59:45

    RE: Export Table and Matrix As Is

    There's already over 5,000 votes in favor of this same topic on another thread that is essentially asking for the same thing. We need to consolidate our votes on this topic, although 5,000 votes apparently hasn't swayed Microsoft to do this already, so maybe it simply doesn't matter. Regardless, here is the link to the other thread: https://ideas.powerbi.com/ideas/idea/?ideaid=b33fc4b3-9dae-4356-973d-d5ffe635ce15

    's profile image Profile Picture

    Mohammed Azhar uddin on 06 Jul 2020 00:17:41

    RE: Export Table and Matrix As Is

    Can community handlers answer if this feature going to be launched anytime soon?

    's profile image Profile Picture

    Liladhar Badgujar on 06 Jul 2020 00:08:26

    RE: Export Table and Matrix As Is

    When will it be available? Because users has to again create pivot out of the data which they downloaded to bring it in the format shown in matrix visual. Also it would be good if it can retain conditional formatting like color, icon.

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:02:11

    RE: Export Table and Matrix As Is

    Tableau Desktop can do this.Power BI should realize this request.

    's profile image Profile Picture

    eeway on 05 Jul 2020 23:55:34

    RE: Export Table and Matrix As Is

    This is very extremely needed. Most user would like to have >> able to export whatever they see. This request has been started since last year, Please make it happen.

    's profile image Profile Picture

    EV on 05 Jul 2020 23:53:31

    RE: Export Table and Matrix As Is

    This is still not available

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:33:38

    RE: Export Table and Matrix As Is

    critical. I can not persuade users to continue using Power BI if they have to redo the same work on Excel export again. When on the very first hand they were initially using excel for these layouts.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:29:20

    RE: Export Table and Matrix As Is

    Microsoft products should work together seamlessly, by not transferring format, the software seems to be incomplete