Skip to main content

    Power BI

    Under Review

    Export data to Excel

    Vote (467) 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 13 Sep 2017 04:16:31

    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

    0029f0b6 b902-4319-a84f-243a5988bab3 on 05 Jul 2020 23:04:56

    RE: Export data to Excel

    Can we export more than 150,000 rows as well? Haven't been able to figure out a way to export more than that.

    's profile image Profile Picture

    092ae602 c105-4150-8d72-0685da5301d8 on 05 Jul 2020 23:03:59

    RE: Export data to Excel

    This is must have feature. I am really dying for this feature. There is also another big issue with PBI Desktop with excel. That we are unable to select PBI Desktop column and rows and paste in excel.
    This facility should be available from Edit Query mode or the Data Mode.

    Thanks

    's profile image Profile Picture

    779eeead 85bd-454a-b39a-4d098eaf4395 on 05 Jul 2020 23:03:41

    RE: Export data to Excel

    Yes please

    's profile image Profile Picture

    6ecfdf2b 4e0f-4ae7-ba13-40133a6eab59 on 05 Jul 2020 23:03:40

    RE: Export data to Excel

    This should be the top priority in term of development. It's a show stopper for user adoption.

    's profile image Profile Picture

    6ecfdf2b 4e0f-4ae7-ba13-40133a6eab59 on 05 Jul 2020 23:03:39

    RE: Export data to Excel

    Kim - We need to export the data as it appear in the table/matrix including formatting, subtotals, etc.

    Also, this is a duplicate of : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13224069-export-excel

    's profile image Profile Picture

    fd9cd438 225b-419d-887f-d606dc5c9bfe on 05 Jul 2020 23:03:09

    RE: Export data to Excel

    '+1

    's profile image Profile Picture

    735629f5 a5cb-e811-a96b-000d3a1bece3 on 05 Jul 2020 23:03:07

    RE: Export data to Excel

    Kim - I fear you haven't understood the request. Making what the service does available on the desktop client doesn't meet the need.

    I agree with Jeff, this should be a WYSIWYG export for the matrix/table visual. Tableau has this feature and it works really nicely to export simple tables of data without having to reformat or worse, rebuild by hand! I'd urge you to download their trial and see what we mean.

    It would also be nice to be able to select to copy and paste individual cells, columns or a range of data within a matrix. But right now i'd settle for a dumb WYSIWIG export of the whole table i could tidy up myself in Excel.

    's profile image Profile Picture

    2e9d4371 c970-4542-afe8-b3da610c62d3 on 05 Jul 2020 23:03:02

    RE: Export data to Excel

    I like chocolate

    's profile image Profile Picture

    ff06745f 4d26-48cc-97af-8086a7d1e3f6 on 05 Jul 2020 23:02:51

    RE: Export data to Excel

    Fully agree with Hugh. This is not fully supported today for Power BI Service... it should be a wysiwyg export for the matrix visual. This is the top request from our company user base.

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:02:49

    RE: Export data to Excel

    Can we get an update on this review? Will a wysiwyg export of a matrix be available in the next 6 months or not? This is a critical feature for many business uses in our company and the main hurdle keeping us from using Power BI for more applications.