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/
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.
We need to be able to export to excel to dump more than the 30,000 rows allowed with .csv files. Don't know why this capability if available in the Web version but not the desktop version of Power BI.
Don't understand why it is so complicated to make export to excel in Power Bi reporting server? We are using in three countries it more than one year and still this functionality not developed. This export to .csv is demotivating for end users. Please plan this!
The first link is going to a 404 page. Please check and update.
Can you export to excel from the published report on the URL eg. app.powerbi.com/view?
The export to CSV works, but than you have to use "text to columns" function - this is something our clients wont spend time with in case they need to copy-paste the report data to their other workbooks/reports. And I cant let them download the whole database either.
It would be very helpful if you (PowerBI developers) could add a function that would export-the-data-and-text-to-column them in one step, or as I like to call it, export to excel.
Definitely not completed. Table visualizations can only export as csv, which isn't very useful when some of the data has commas in it!