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)
RE: export excel
I was able to get images to display in a report using an image URL and it looks and works very well. However, I was very disappointed when I exported the report to Excel and the image column was populated with the image URL as opposed to the asset itself. I would love to export a report to Excel and see an identical report to what I see in the Power BI Service.
RE: export excel
The current export to excel functionality is too cumbersome. I should not have to save the file as a .csv. During validation of reports it is extremly useful to be able to quickly copy a chart/matrix/list/whatever visual to excel. This also includes the underlying data. This is possible in Tableau, which makes data validation much easier, quicker and more accurate. Also, Analyze in Excel does not work for this purpose, I want to see exactly what is included in the numbers in the visual.
RE: export 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)
RE: export excel
Does it also export pivot table view as it to excel?
RE: export excel
Export whole report to Excel is what needed, but not visual wise data export to Excel
RE: export 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.
RE: export excel
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....
Idea posted here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39585493-export-the-exact-display-to-excel-like-ssrs
RE: export excel
All bigger BI tools are able to export to Excel, and you guys own Excel. Please fix! Very important AND business critical.
RE: export excel
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!
RE: export excel
Please include a process to automate exporting, from either visuals or tables (using DAX Expressions)