Skip to main content
Microsoft Idea

    Power BI

    Completed

    Export data to Excel

    Vote (497) Share
    's profile image

    on 16 Jun 2016 04:52:21

    It would be nice to have the option to export a table to an excel file, right now is only on CSV format but someone working on a different ecosystem and does not have Power Bi would need to rework the data and that does not make any point to have PowerBi

    Administrator on 18 Apr 2022 20:34:56

    This is supported today in the Power BI service; however, it is not yet supported in Power BI Desktop. We'll consider this for a future release.

    Comments (39)
    's profile image Profile Picture

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

    RE: Export data to Excel

    Sorry and following my comment below, all you would need to do - at a minimum - is allow the user to copy the SEE DATA view. You know, move their cursor over the SEE DATA table and press copy and then paste! But alas. HELP!!!

    's profile image Profile Picture

    Dave Poggi on 05 Jul 2020 23:00:07

    RE: Export data to Excel

    The minimal feature in PBI online is inadequate. Structure and formatting are lost even when going directly to Excel. Qlik and other tools give a true representation of what's on the screen for all types of charts and graphs. We're trying to replace Qlik with PowerBI for all of our clients and this is the only real problem. Please fix this - it's a huge issue for accountants and others who insist on an Excel version "they control, so they trust won't change" and that they can easily annotate using Excel.

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:59:40

    RE: Export data to Excel

    Is it really already available in Power BI service? It doesn't appear to be.

    's profile image Profile Picture

    a.massip on 05 Jul 2020 22:57:06

    RE: Export data to Excel

    This feature exists in the on-line version.
    Why not to have put back it in the version PowerBI desktop report server?

    Thanks

    's profile image Profile Picture

    Joe Natarajan on 05 Jul 2020 22:56:31

    RE: Export data to Excel

    Exporting from Matrix table to excel gives us just the flat table and we lose subtotals etc. It will save so much time for us if it exports in the same format as Matrix with subtotals etc. We now have to create another pivot table in excel to mimic the matrix visual . Our Senior executives cannot do this and it is frustrating because we have to recreate in excel and send it to them by email .Please fix this. Many Thanks !

    's profile image Profile Picture

    Elder Carvalho on 05 Jul 2020 22:52:19

    RE: Export data to Excel

    For more export limit and to be able to export directly to Excel from PBI Embedded, please vote on the idea:

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19741078-export-to-excel-from-powerbi-embedded

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:51:24

    RE: Export data to Excel

    Unfortunately MS closed 13224069 without reading the details. Users are asking for more than a .csv file. The use case calls for exporting data from the Matrix with filtering and formatting applied.
    Please keep voting for this Idea to keep the request alive.

    's profile image Profile Picture

    Mikhail Ovchinnikov on 05 Jul 2020 22:36:32

    RE: Export data to Excel

    Duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel

    's profile image Profile Picture

    Mandakh Ganbold on 05 Jul 2020 22:34:01

    RE: Export data to Excel

    It would be really nice to have both visuals and its data of the report exported to Excel.