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

Mark Stein on 05 Jul 2020 23:23:26

RE: Export charts directly to excel

Agree!

Richard Javier Perez Cubas's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:20

RE: Export charts directly to excel

Power BI is a nice tool for viewing info from a Computer screen but terrible for downloading info. Need to find a way to download info in the same format as what you see on the computer screen. Way to much Cut/Paste/V-Loop, summaries....manual work.

Richard Javier Perez Cubas's profile image Profile Picture

Laura Horjea on 05 Jul 2020 23:14:20

RE: Export charts directly to excel

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

Jack Wells on 05 Jul 2020 23:13:42

RE: Export charts directly to excel

This is quite a basic function that rivals have been doing for some time.

Richard Javier Perez Cubas's profile image Profile Picture

Mila Kajnarova on 05 Jul 2020 22:32:46

RE: Export charts directly to excel

1) Export data behind chart to Excel format ( not just .csv format) + 2) function of copy-paste charts (not only using print screens) are the key for Reports and presenting / analyzing the data . These two issues I see as big PBI disadvantage . Sure we can convert .csv format by using "Text to columns" to Excel columns structure BUT (!) If one of the details e.g. Project describtion includes "comma" within , then we can not split data to columns using "comma" as delimiters because then "project name" (includes comma) will be split un-correctly to two or even more columns, rather to stay within one column only. Hope Microsoft Office will take care and fix is asap. I think Excel format export should be as s standard.

Richard Javier Perez Cubas's profile image Profile Picture

Joseph on 05 Jul 2020 22:23:33

RE: Export charts directly to excel

I agree. I use excel to do more computational analysis with data and it's a pain to re-format the data or have to pull the data out with a dynamic pivot from the database (that can take a lot of time).
Thank you and I hope more people vote for this.
Joseph

Richard Javier Perez Cubas's profile image Profile Picture

sandra on 05 Jul 2020 22:22:13

RE: Export charts directly to excel

I have the same problem, data is exported in an incorrect format
Thanks so much!

Merged Idea (2)