Power BI

Completed

export excel

Vote (1141)

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)

Comments (99)

Power BI User on 05 Jul 2020 23:08:17

RE: export excel

Can I export the data with all the transformations I did in Power BI to excel/csv?

Eric Phillips on 05 Jul 2020 23:06:28

RE: export excel

All BI tools let you export to Excel in the view you are analyzing. Business professionals need to save snapshots of the data to report to Upper Management (CEO, CFO, Controllers), Customers, Suppliers, Share Holders and Colleagues. Without this feature this tool will not be adapted fully.

Power BI User on 05 Jul 2020 23:06:27

RE: export excel

I agree with the above comments! This is not fixed and it does not work in desktop.

Power BI User on 05 Jul 2020 23:05:47

RE: export excel

Please reopen this idea for review. I agree with the latest comments, we need the option to export from P BI to Excel in the same way we look in power bi!

Zoe on 05 Jul 2020 23:04:31

RE: export excel

'@Kim, please reopen this, this has not been completed. Need to be able to export to Excel from desktop, not just service. Anyway, the 'analyze in excel' gives you a pivot table, also not what's being asked here. I don't understand why this is so difficult? You can do this in Tableau.

LCorales on 05 Jul 2020 23:04:12

RE: export excel

Excel option not aviable in Desktop, and web link into Microsoft Teams Report.
Please your publish this options, but i liked yor config this option in level config when develop in desktop or both

Charanjit SINGH Channi on 05 Jul 2020 23:04:00

RE: export excel

This is must have feature. I am really dying for this feature. There is also another big issue with PBI Desktop with excel. That we are unable to select PBI Desktop column and rows and paste in excel.
This facility should be available from Edit Query mode or the Data Mode.

Thanks