Skip to main content

Power BI

Under Review

Export charts directly to excel

Vote (1814) 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 (127)
Richard Javier Perez Cubas's profile image Profile Picture

Yuvraj on 06 Jul 2020 00:17:29

RE: Export charts directly to excel

Really need this feature

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:37

RE: Export charts directly to excel

This idea is 4 years old with many votes, any comment please?

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:37

RE: Export charts directly to excel

An option to export data from table/ matrix visuals as displayed with conditional formating would definitely be very useful.

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:07

RE: Export charts directly to excel

there are more people here requesting this feature: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19859494-enable-total-row-also-to-be-exported

Richard Javier Perez Cubas's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:12:21

RE: Export charts directly to excel

BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals

Go to https://bihelper.tech/bihelper_matrix.html.

Visual formatting and matrix data pivots retained in Excel download.

Secure Microsoft login - use your Power BI login to access Matrix 4.0.

Free 14 day trial.

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:26

RE: Export charts directly to excel

This is a constant issue with users in Qlik who do not want to give up this feature to come to PowerBI

Richard Javier Perez Cubas's profile image Profile Picture

Raazia Shafqat on 06 Jul 2020 00:10:38

RE: Export charts directly to excel

I need this feature. Please add or fix

Richard Javier Perez Cubas's profile image Profile Picture

alessandro on 06 Jul 2020 00:10:34

RE: Export charts directly to excel

Please take care of this request! Not having this possibility is an incredibly huge limit to Power BI.

Richard Javier Perez Cubas's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:09:10

RE: Export charts directly to excel

This is solved - we've built and launched a Chrome extension called BI Helper Matrix for table and matrix data exports from Power BI. See my post dated Feb 24, 2020.

Go to https://bihelper.tech/bihelper_matrix.html to download and test the solution.

Richard Javier Perez Cubas's profile image Profile Picture

Kiran Hosakote on 06 Jul 2020 00:08:45

RE: Export charts directly to excel

BI Helper Matrix

BI Helper Matrix is a powerful and easy to use Chrome extension for Matrix and Table data exports from Power BI. You can download your Power BI matrix and table visuals as MS Excel files, with support for full vertical and horizontal scrolling of the visuals.

The Excel file retains your matrix data pivots, so you continue to see your information at the SAME level of detail as in your Power BI report. Download and test BI Helper Matrix at https://bihelper.tech/bihelper_matrix.html.

Merged Idea (2)