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 (97)
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.
RE: export excel
Export just exports data and not the visualization (Matrix table , Chart etc.). It will be really good to have a feature where it can export as is from power BI .
RE: export excel
The ability to export to excel for table visuals is very useful but the order of the columns when doing an export to excel does not make sense. The order can be set a certain way in Power BI table visual, then when exported to excel the columns are in a completely different order. This does not happen when exporting to CSV.