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

    da42de3c 62fc-4cb4-98ce-3f9dd7164590 on 05 Jul 2020 23:06:27

    RE: export excel

    I agree with the above comments! This is not fixed and it does not work in desktop.

    info's profile image Profile Picture

    75ae757d c916-4177-bd9d-7705dd2ffb3a on 05 Jul 2020 23:05:47

    RE: export excel

    Please reopen this idea for review. I agree with the latest comments, we need the option to export from P BI to Excel in the same way we look in power bi!

    info's profile image Profile Picture

    c4439f19 9722-4e45-8a19-dd324f9f5dd4 on 05 Jul 2020 23:04:31

    RE: export excel

    '@Kim, please reopen this, this has not been completed. Need to be able to export to Excel from desktop, not just service. Anyway, the 'analyze in excel' gives you a pivot table, also not what's being asked here. I don't understand why this is so difficult? You can do this in Tableau.

    info's profile image Profile Picture

    bf008505 1706-45ec-819c-ebc7376e2243 on 05 Jul 2020 23:04:12

    RE: export excel

    Excel option not aviable in Desktop, and web link into Microsoft Teams Report.
    Please your publish this options, but i liked yor config this option in level config when develop in desktop or both

    info's profile image Profile Picture

    092ae602 c105-4150-8d72-0685da5301d8 on 05 Jul 2020 23:04:00

    RE: export 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

    info's profile image Profile Picture

    1b906d44 0471-40f4-b558-c42cfb0db333 on 05 Jul 2020 23:02:31

    RE: export excel

    Hello,

    Is the excel export also available forPower BI Desktop ? And if not, when will it become available ?

    info's profile image Profile Picture

    714adb87 c21e-4aca-bb94-e880ba030ddc on 05 Jul 2020 23:02:03

    RE: export excel

    We need to export the data as they appear in PowerBI. Currently it is a very summarized version, specially for pivot tables

    info's profile image Profile Picture

    b06e72f9 cde1-4340-9122-a143f0fb497a on 05 Jul 2020 23:01:47

    RE: export excel

    This is not completed. See duplicate https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14824779-export-data-to-excel#comments

    info's profile image Profile Picture

    4963ba3a 1444-4778-a338-e12b92845fef on 05 Jul 2020 23:01:01

    RE: export excel

    Kim for user convert csv file to excel file is a re-work. We need to export the grid as the same way we look in power bi

    info's profile image Profile Picture

    5dc273da 419d-42a3-9c6d-74fea1359a63 on 05 Jul 2020 22:56:36

    RE: export excel

    Can we also support exports for visuals that use custom calculated measures?