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
To export data from Power BI to Excel, it takes additional time by using Power BI service.
Thus I wish very much that we can do this from Power BI desktop directly.
RE: export excel
Power BI Report Server needs to be able to Export to Excel formatted table. It has to roughly match the table - ordering of columns and rows, number formatting etc.
RE: export excel
Be able to export data from Power BI Desktop.
Also, on the service, you can export the data to Excel. What about exporting the graphs that were created to Excel?
RE: export excel
NOT solved, if you deploy in power-bi embedded no export to excel option
RE: export excel
As per others on here, I really don't agree this is fixed. Personally I would like the ability to be able to export in an Excel format from Power BI desktop. I don't see the need to have published the report before allowing exports in this format. If this could be resolved then that would be great!!
RE: export excel
Hi Kim. This is NOT enough. Without the possibility to export in Excel the view as it is on your screen (not the underlying data ... ), this is in most cases useless. All other previous BI tools in my company have that functionnality so users are pushing, this is CRITICAL for business users.
RE: export excel
I would like to Export the entire report, with charts and graphs and tables, into an excel sheet, automatically creating number of Work Sheets equal to number of Pages on the power BI Report. Exporting the underlying data doesn't help the end users.
RE: export excel
Report server still only has export to .CSV
RE: export excel
I would like to be able to save as an excel spreadsheet from the desktop Power BI, NOT publishing it and then exporting. That's too much work. Currently I'm manually taking screen shots and posting the spreadsheet on our SharePoint site. Thanks
RE: export excel
What about those of us using Power BI Report Server?