Export a report directly in Excel (not only via csv file)
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/
Anyone know when we'll be able to export all visuals in one go as part of a PBI report (instead of using paginated reports)
Amardeep Bhingardeve commented
Does it also export pivot table view as it to excel?
Export whole report to Excel is what needed, but not visual wise data export to Excel
First option is not working for end users who are working with powerbi app. Please add functionality of export to Excel on powerbi app level. User can not see buttons on each visual while he is using powerbi app.
We thought that the Export to excel would include the same export functionality as SSRS... The exact same report display with totals and subtotals, etc. "What you see is what you get". Is this on the radar? Our client needs that otherwise we might just go back to SSRS....
Christian Hallqvist commented
All bigger BI tools are able to export to Excel, and you guys own Excel. Please fix! Very important AND business critical.
This functionality does not exist for Report Server. Dear Microsoft are You aware that this is number one feature for end users? Export to CSV is to complicated for number of them.
Please add it as ASAP as possible!
Luigi Ho-tien-ton commented
Please include a process to automate exporting, from either visuals or tables (using DAX Expressions)
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 commented
In Report Server, not export to *.xlsx file, only *.csv
Add export to EXCEL for REPORT SERVER.
Johnny HIramoto commented
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 commented
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.
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.
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 commented
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.
Report server still only has export to CSV and we really need to export to excel for this to be viable
Please add this to desktop as well. I am aware that service has the functionality.
Lack of ability to Export the whole Report into Excel is preventing our business users from adopting PowerBi
This still isn't solved. Need to export as shown in the matrix.
Kim people want it in the basic version powerbi as service is down right to expensive for most small businesses.