Skip to main content
Microsoft Idea

    Power BI

    Under Review

    Export charts directly to excel

    Vote (1775) Share
    Richard Javier Perez Cubas's profile image

    Richard Javier Perez Cubas on 19 Dec 2017 06:25:17

    It would be very useful if Power BI allow to export charts directly to excel without lose the format. Exporting just like values with format.

    Administrator on 01 Apr 2024 05:47:37

    We are looking at supporting this once Loop becoems available in Excel

    Comments (123)
    Richard Javier Perez Cubas's profile image Profile Picture

    Doug Stevens on 16 Nov 2022 20:01:55

    RE: Export charts directly to excel

    So much meaning is stored in the cell background colours. Not having them in the export to excel means that we have to reformat the export using excel's conditional formatting. Frustrating.

    Richard Javier Perez Cubas's profile image Profile Picture

    Chris M on 31 Aug 2022 15:09:00

    RE: Export charts directly to excel

    I am currently having to apply a manual workaround to re-apply conditional formatting that is lost when exporting to Excel from a Matrix. This is causing a lot of problems for our users who rely on the colour coding for effective analysis. I would greatly appreciate if there was an option to be able to export to Excel and retain all formatting including conditional formatting, as is the case with similar applications. Thanks.

    Richard Javier Perez Cubas's profile image Profile Picture

    Jillian Kratish on 26 Jun 2022 23:01:34

    RE: Export charts directly to excel

    You can do this with Power BI Robots. It's something I only learned recently, so might get some details wrong. But when adding visuals, I kept going past the page image to the table image, and was able to export the data to excel in that exact format. I think there was a setting on the General tab that I had to select for that to work, in the Output Format field.

    Richard Javier Perez Cubas's profile image Profile Picture

    on 05 May 2022 23:00:47

    RE: Export charts directly to excel

    Please upgrade/include the below mentioned feature in "export to excel" option.

    * Export Table or Matrix or Any Visuals to excel with the same look as it is in the PBI report/dashboard.

    Richard Javier Perez Cubas's profile image Profile Picture

    on 05 May 2022 23:00:45

    RE: Export charts directly to excel

    Power BI based Tables could be exported. But this export covers only the export of underlying data not the formatting or even column design.

    Richard Javier Perez Cubas's profile image Profile Picture

    on 05 May 2022 22:43:59

    RE: Export charts directly to excel

    Power BI users would benefit immensely if they can export a data set from a visual without losing the formatting as displayed on the browser. Currently the export option loses the formatting and exports data that requires additional pivoting for users to get the layout right for their perusal.

    Richard Javier Perez Cubas's profile image Profile Picture

    on 05 May 2022 22:43:59

    RE: Export charts directly to excel

    Buonasera,

    vorrei esportare in excel i report che costruisco in power bi visualizzandoli con lo stesso layout predisposto su power bi...grazie

    Good evening,

    I would like to export the reports that I build in power bi to excel, displaying them with the same layout prepared on power bi ... thanks

    Richard Javier Perez Cubas's profile image Profile Picture

    on 05 May 2022 22:43:59

    RE: Export charts directly to excel

    Hi
    Currently its not possible to export data in the Matrix visual to Power BI in the layout it displays in the matrix.

    Adding this would be a great hep to the end users of the report

    Thank you
    Geogie

    Richard Javier Perez Cubas's profile image Profile Picture

    Sergey Parkhomenko on 03 May 2022 15:55:06

    RE: Export charts directly to excel

    Business needs this features and especially in 2022, please implement ASAP - thank you!

    Richard Javier Perez Cubas's profile image Profile Picture

    Tejomay Pandya on 11 Apr 2022 08:56:03

    RE: Export charts directly to excel

    Need this feature ASAP

    Merged Idea (2)