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

56571612 0da1-413d-908f-6b9ba3ca9d4d on 05 Jul 2020 23:54:28

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

Sarva's profile image Profile Picture

6419141e dce5-4e07-ae9b-c719592b6211 on 05 Jul 2020 23:50:22

RE: Power BI - Export Data to Excel.

Exporting the data in the format it is already in PowerBI would be more efficient and is very much needed. Please add or fix this. Thank you!

Sarva's profile image Profile Picture

42afcb50 dfa8-408d-9d86-2689366d23ed on 05 Jul 2020 23:48:36

RE: Power BI - Export Data to Excel.

Please solve this issue ASAP as it's extremely crucial for business to be able to export in the format you already built. Thank you in advance for your help!

Sarva's profile image Profile Picture

6194bc6c 0572-4604-8ee0-427123960022 on 05 Jul 2020 23:48:31

RE: Power BI - Export Data to Excel.

i need this very much.. i need to export with colors

Sarva's profile image Profile Picture

be336bae 0b51-4625-bfcf-d1c2d5d69fca on 05 Jul 2020 23:47:21

RE: Power BI - Export Data to Excel.

Could be very helpful for the users of my report to show differences and repair data as a data analyst.

Sarva's profile image Profile Picture

2d177e8d 6416-434d-97dd-b44cb4315685 on 05 Jul 2020 23:39:01

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

Sarva's profile image Profile Picture

3ba22058 ea69-430c-9e8a-3b491fba6d1d on 05 Jul 2020 23:39:01

RE: Power BI - Export Data to Excel.

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

Sarva's profile image Profile Picture

41f7e4e6 29fa-4cda-9776-a2a23560b105 on 05 Jul 2020 23:35:42

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

Sarva's profile image Profile Picture

58c6a4a9 85ff-48b4-89a8-92d1464e59de on 05 Jul 2020 23:29:06

RE: Power BI - Export Data to Excel.

Could not explain to the sponsor that we cannot export report's view in Excel. Users do not have to rebuild the report in Excel ! This is so critical for business users, thanks.

Sarva's profile image Profile Picture

1f86a53a 7337-4840-ae73-bea576669207 on 05 Jul 2020 23:14:20

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