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
Hi Kim, sorry but the solution is not sufficient...for example, the applied filters should persist and should be reflected somewhere in the result set for consistency. Also, if an object has fold/unfold, that functionality should persist (it's basic excel functionality already).
RE: export excel
Kim, I've asked our Microsoft representative to let me know if I need to submit a new idea or if this status can be changed. Not having a feature that every decent data grid tool on the market provides gives validity to keeping this idea open. You have 'export excel' - you don't have "Export the data you have filtered and formatted to Excel without rework". Please reopen this idea for review.
RE: export excel
Kim, have you read the comments? I think the users are clearly saying that reworking the data is not acceptable. So I am asking you - do I need to more clearly define the idea and resubmit or will you reopen?
RE: export excel
Most of our users want to be able to export a report's results to excel and be able to work with their export to make some further changes.
RE: export excel
Power BI has come a long way and I like it a lot, but this feature is critical in order for us to consider it as a solution for our organization. Our current BI platform has this capability, though it falls short elsewhere.. but not enough for our users to buy in to the change.
RE: export excel
I cannot fathom why this would even be in question. csv is not a substitute
RE: export excel
The maximum number of rows that can be exported to .xlsx is 30,000 (for Power BI Free users) and 150,000 (for Power BI Pro users).
RE: export excel
Full agree with this. Our customers use "QlikView" and would like to replace by PowerBI.
RE: export excel
Without the ability to open a WYSIWYG view of the Power BI pages we can't replace QlikView with Power BI. Users need to leverage the PBI work and customize a little from there, not completely rebuild the report. Also, the CSV and PowerPivot options don't provide output consistent to PBI so financial people don't consider a CSV file as a reliable source for referencing previous periods.
RE: export excel
The biggest obstacle for adoption of Power BI within financial reporting is the ability to have a copy within Excel; last two projects client have stipulated a requirement for export to Excel for offline version. The issue has been they currently have Excel reports that have multiple worksheets within a workbook.