Skip to main content

    Power BI

    Completed

    export excel

    Vote (1141) Share
    info's profile image

    info on 31 Mar 2016 03:01:02

    Export a report directly in Excel (not only via csv file)

    Administrator on 16 Jun 2017 23:49:13

    Exporting to Excel from Power BI is supported. You have two options for exporting your data to Excel: * Once you publish to the Power BI service, you can export your data to Excel by clicking on the ... button for any visual. See more info here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/ * You can use the Analyze in Excel feature to connect directly to your model in Excel: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/

    Comments (97)
    info's profile image Profile Picture

    3ff5b3d0 c301-41c4-9dbb-da8a22186f43 on 06 Jul 2020 00:15:06

    RE: export excel

    Anyone know when we'll be able to export all visuals in one go as part of a PBI report (instead of using paginated reports)

    info's profile image Profile Picture

    e3bc739d 95dd-4d7e-b757-44b58326b27d on 06 Jul 2020 00:14:01

    RE: export excel

    Does it also export pivot table view as it to excel?

    info's profile image Profile Picture

    5af290a4 6f5e-4545-8682-a1598c40663d on 06 Jul 2020 00:11:43

    RE: export excel

    Export whole report to Excel is what needed, but not visual wise data export to Excel

    info's profile image Profile Picture

    bd616b04 a7e1-451c-a702-4f51c3619747 on 06 Jul 2020 00:11:37

    RE: export excel

    First option is not working for end users who are working with powerbi app. Please add functionality of export to Excel on powerbi app level. User can not see buttons on each visual while he is using powerbi app.

    info's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:07:24

    RE: export excel

    We thought that the Export to excel would include the same export functionality as SSRS... The exact same report display with totals and subtotals, etc. "What you see is what you get". Is this on the radar? Our client needs that otherwise we might just go back to SSRS....

    Idea posted here:
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39585493-export-the-exact-display-to-excel-like-ssrs

    info's profile image Profile Picture

    2628eb46 7d1a-48a5-af5c-358d244c6014 on 06 Jul 2020 00:05:59

    RE: export excel

    All bigger BI tools are able to export to Excel, and you guys own Excel. Please fix! Very important AND business critical.

    info's profile image Profile Picture

    9c8e6fe3 a63c-406f-a73d-6f61deb432ba on 06 Jul 2020 00:01:06

    RE: export excel

    This functionality does not exist for Report Server. Dear Microsoft are You aware that this is number one feature for end users? Export to CSV is to complicated for number of them.

    Please add it as ASAP as possible!

    info's profile image Profile Picture

    9e1e1cfd c2e8-4c6c-85a7-ccd7df9ed392 on 06 Jul 2020 00:01:01

    RE: export excel

    Please include a process to automate exporting, from either visuals or tables (using DAX Expressions)

    info's profile image Profile Picture

    9e276396 580e-415e-ace8-aaf263ab0a60 on 06 Jul 2020 00:00:12

    RE: export excel

    Please allow us to programmatically export data from the model in PBI desktop. I have several bookmarks that I use to export certain views of the data on a weekly basis. I would like to automate this using a code-based-button.

    info's profile image Profile Picture

    2bf75b9d 5fe2-4ab0-8828-12bd3cfd4f8b on 05 Jul 2020 23:59:56

    RE: export excel

    In Report Server, not export to *.xlsx file, only *.csv
    Add export to EXCEL for REPORT SERVER.