Power BI

Completed

export excel

Vote (1141)

info on 31 Mar 2016 03:01:02

Export a report directly in Excel (not only via csv file)

Administrator on 16 Jun 2017 23:49:13

Exporting to Excel from Power BI is supported. You have two options for exporting your data to Excel: * Once you publish to the Power BI service, you can export your data to Excel by clicking on the ... button for any visual. See more info here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/ * You can use the Analyze in Excel feature to connect directly to your model in Excel: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/

Comments (99)

Comments (99)

Power BI User on 06 Jul 2020 00:00:12

RE: export excel

Please allow us to programmatically export data from the model in PBI desktop. I have several bookmarks that I use to export certain views of the data on a weekly basis. I would like to automate this using a code-based-button.

Nikolay Marchuk on 05 Jul 2020 23:59:56

RE: export excel

In Report Server, not export to *.xlsx file, only *.csv
Add export to EXCEL for REPORT SERVER.

Johnny HIramoto on 05 Jul 2020 23:59:55

RE: export excel

plus export to Excel in the format that it is displayed, such as if the date is by month in columns, the export should be the same and not "stack" the data in rows.

Davidson Lima on 05 Jul 2020 23:59:21

RE: export excel

It's odd Microsoft haven't already given a proper solution for that. No, it's not possible to export the entire report following simple formatting (e.g.: row filter, table style) to a xlsx file for desktop users: you simply get a comma-separated-data that demands extra work, every time. You can try DAX studio, but it's a hack.

anonyme on 05 Jul 2020 23:58:37

RE: export excel

'Export to Excel is only available on the service.
It would be useful for key users to adpot PowerBI to get at least :
- a clean export to Excel for other visuals s: MATRIX especially
- the ability to export a full report in Excel : doing 50 times a dozen of export is time-consuming and not user friendly at all.

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

RE: export excel

There is something called UserExperience... and From that point of view, if I need to export 20 things per day, and I need to click each time on export, download it, open it in xl, click on Data, click on Text to Columns, answer 10 questions the wizard.. its anoying, and time consuming... and you need to instruct people to do this

Excel is a Format that belongs Microsoft, so is there a reason, not being able to export it directly in that format, and save a lot a lot of time ! ??

At the moment, I can't see that feature on Report Server on Premise, will it be available there too ??

Josef Kuenzli on 05 Jul 2020 23:54:26

RE: export excel

This isn´t completed. A user can only export the underlying data, but not the visual.
Already having the ability to export a visual as a gif would be of use.