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)
- Merged Idea (2)
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.
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
RE: Export charts directly to excel
I have the same problem, data is exported in an incorrect format
Thanks so much!