Skip to main content

Power BI

Needs Votes

Power BI - Export Data to Excel.

Vote (203) Share
Sarva's profile image

Sarva on 23 Feb 2016 16:09:04

Power BI based Tables could be exported. But this export covers only the export of underlying data not the formatting or even column design.

Comments (24)
Sarva's profile image Profile Picture

2826746b 8215-4a3d-9ec2-66c1eaa6166e on 05 Jul 2020 23:13:42

RE: Power BI - Export Data to Excel.

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

Sarva's profile image Profile Picture

0758fed4 43c1-44a3-abd3-93d570556e17 on 05 Jul 2020 22:32:46

RE: Power BI - Export Data 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.

Sarva's profile image Profile Picture

ecb2e0f2 8443-42ea-af4d-9293229b610f on 05 Jul 2020 22:23:33

RE: Power BI - Export Data 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

Sarva's profile image Profile Picture

343a3b8b cbe0-4ba8-8da6-034b801a7b11 on 05 Jul 2020 22:22:13

RE: Power BI - Export Data to Excel.

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