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

Tom on 05 Jul 2020 23:59:23

RE: Export charts directly to excel

Is this another "how hard can it be" issue?

Our (non technical) users are hugely frustrated that they don't get what they see on screen.

Richard Javier Perez Cubas's profile image Profile Picture

John Guy on 05 Jul 2020 23:59:06

RE: Export charts directly to excel

100% agree with this. The conditional formatting capability within PowerBI is fantastic for analysing data, however when exporting to Excel this is lost...

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:04

RE: Export charts directly to excel

This feature is a big requirement from my customer to agree to move their reports to Power BI. Please implement this like it is in SSRS!

Richard Javier Perez Cubas's profile image Profile Picture

Lukas on 05 Jul 2020 23:58:04

RE: Export charts directly to excel

When this will be implemented ? Many of our internal users dont want to export the data to excel up to the lowest granularity.
All they need is a high level view for them to copy to excel.

Richard Javier Perez Cubas's profile image Profile Picture

Lukas on 05 Jul 2020 23:58:04

RE: Export charts directly to excel

any update from Microsoft?

Richard Javier Perez Cubas's profile image Profile Picture

Sat on 05 Jul 2020 23:56:11

RE: Export charts directly to excel

An option to export data from table/ matrix visuals as displayed would definitely be very useful. All of my report users ask for this. Shamelessly, they are manually typing matrix data because Power BI can only export underlying data, not the matrix/pivoted data they see in Power BI report.

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:55:45

RE: Export charts directly to excel

Please see https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15164733-allow-table-and-matrix-data-exports-to-match-power for updates from Microsoft on this topic

Richard Javier Perez Cubas's profile image Profile Picture

cv on 05 Jul 2020 23:54:47

RE: Export charts directly to excel

1. Export to Excel (like in SSRS)
2. Python support

Richard Javier Perez Cubas's profile image Profile Picture

Alex Robe on 05 Jul 2020 23:54:37

RE: Export charts directly to excel

Definitely a veery often needed ability - currently more than just a hassle. Thanks!

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:54:28

RE: Export charts directly to excel

Why SSRS has no problem doing this and we still can't even export formatted charts to Excel with a 'Premier' tool is amazing. Can't even use paginated reports unless I want to spend $5k a month to do so.

Merged Idea (2)