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
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.
RE: export excel
Full agree with this. We use "QlikView" in my company and would like to replace by PowerBI.
Unfortunaterly, the very convenient one-click button feature "Excel export" available in Qlikview does not exist (yet) in PowerBI (at least in Power BI DEsktop, when preparing and checking data)... Or maybe I missed it in a recent update ?
Would be a great step ahead for global usage of PowerBI !
thanks
Olivier
RE: export excel
voting for this. If PBI is to be used widely within our company we need it to be able to export to excel. CSV is not really acceptable for our management and less technical users.
RE: export excel
This is very important as some of the danish/norwegian etc. letters isn't shown correctly in a CSV export. It would be truly awesome if a user could actually do some filtering and then export an excel file with the filters applied - Maybe even export a certain tile (a list for instance) with a filtered view of the data on the list.
RE: export excel
It's very neccesary. I agree with the following:
Timo commented · September 13, 2016 03:54 · Flag as inappropriate
This would be especially useful for the Matrix visual to export analysis results in form they're presented in the visual including totals and subtotals so that the analysis result can be used in other office apps i.e. for presentations
RE: export excel
I will vote again for this idea. My boss told me that he need some reports in Excel.
RE: export excel
exporting a dataset based on selection / filters you apply in the dashboard could solve segmentation queries in other business solutions. a data set of customer contacts is surfaced in PowerBI, based on the time dimension and a product family (sold products), selecting a time window and productfamily followed by an export to Dynamics CRM (by means of Flow)?
RE: export excel
This would be extremely useful.
In SSRS, there's a simple function where you can export the data to Excel and it will open in the tool as soon as you've pressed the button. Having to export it, locate the file and then open it, while not the most onerous task, is just plain annoying.
RE: export excel
An Export to Excel should solved two problems: the line feed and the extended characters.
Currently the generated CSV is well formatted but encoded in UTF-8 and Excel has not option to open file with this encoding. The only option is to "import from text" but doing this way your facing the "linefeed issue". The import text wizard is not able to understand that some column can have a line feed in the content.