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

Power BI Ideas Admin on 05 Jul 2020 23:42:53

RE: Export charts directly to excel

It's a real shame that this isn't available. Visuals like charts and matrices on SSRS reports can be exported directly to Excel so it makes total sense that this feature be available to Power BI.

Richard Javier Perez Cubas's profile image Profile Picture

DebinFl on 05 Jul 2020 23:41:26

RE: Export charts directly to excel

I find it hard to believe this doesn't exist. I came from a MicroStrategy background and it can do this. Also, need to make sure TOTALS export as well

Richard Javier Perez Cubas's profile image Profile Picture

anonymous on 05 Jul 2020 23:40:31

RE: Export charts directly to excel

Same for us- We want to purchase licenses for 150 pro users, but until the matrix can be downloaded to Excel, the users will not accept Power BI as a solution. Please advise as to release date for this.
We would also like to be able to influence the download in other ways- such as autoformatting column width, including subtotals as shown in Power BI, etc. Other non Microsoft BI reporting tools have the capability to do all of these things. How can a Microsoft BI to Microsoft Excel not have this functionality?
We can not roll the tool out and buy licenses until this is resolved. Please advise on release date for Pro Services. Thanks.

Richard Javier Perez Cubas's profile image Profile Picture

Justin on 05 Jul 2020 23:40:28

RE: Export charts directly to excel

This is very necessary for our company. We will not be able to proceed with Power BI without this function.

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:13

RE: Export charts directly to excel

Definitely need the ability to export into Excel with visuals intact. This can currently be done in ClickBase but not in Power BI

Richard Javier Perez Cubas's profile image Profile Picture

Ron Paider on 05 Jul 2020 23:39:01

RE: Export charts directly to excel

Yes, what Laura Horjea said, "An option to export data from table/ matrix visuals as displayed would definitely be very useful. Quite surprised this bit of functionality doesn't already exist."

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:01

RE: Export charts directly to excel

Agree that exporting data as displayed would be very useful and a time saver.

Richard Javier Perez Cubas's profile image Profile Picture

carl on 05 Jul 2020 23:36:53

RE: Export charts directly to excel

The ability to copy a formatted table / matrix and paste as a editable table into other applications (Excel being the obvious) is necessary to quickly share insights.
More complex visuals could be pasted as an image in order to maintain a consistent UI.

Richard Javier Perez Cubas's profile image Profile Picture

Mithras L. on 05 Jul 2020 23:35:42

RE: Export charts directly to excel

Yes, nobody wants to rebuild the tables from scratch with csv in excel.

There should be a new option: export table as shown or export current view

Richard Javier Perez Cubas's profile image Profile Picture

Hisaka Kuriyama on 05 Jul 2020 23:33:17

RE: Export charts directly to excel

Our company strongly demands this function.

Merged Idea (2)