export excel

[info166]

Export a report directly in Excel (not only via csv file)

[pbiideas1]

Hello Kim, I agree with Danny, that's why this idea was submitted. The functionality you provide is helpful for some use cases but there are many where it falls short of what other BI tools are providing - an option to export a data grid with the applied filters and in a format that doesn't require rework. Many use cases call for passing data in Excel to others for their consumption or aggregation.

[pbiideas1]

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.

[abeer2]

I agree with the latest comments. Can you reopen? We would like a way to export to excel in the exact format you see on the screen, with totals included, etc.

[fbcideas_migusr]

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).

[carvalhoelder]

For more export limit and to be able to export directly to Excel from PBI Embedded, please vote on the idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19741078-export-to-excel-from-powerbi-embedded

[dcg_brian]

We need to be able to export from the desktop and everything should be exportable.

[selamatng]

Kim, i think the ability to export to Excel from Power BI Desktop is really important. There is no reason for us to publish it online and export from there. You know what we are trying to mention about.

[fbcideas_migusr]

Kim - Having the CSV export is nice, but it means a huge amount of re-work for users to re-format the data back into a report layout. Can we please re-open this request to export the entire visual as-is (formatting, selected slicers, etc.) into Excel? Alternatively, anyone who agrees please up-vote this request which asks for the same: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14824779-export-data-to-excel

[narayenmusic]

Can we also support exports for visuals that use custom calculated measures?

[andresmaderna]

Kim for user convert csv file to excel file is a re-work. We need to export the grid as the same way we look in power bi