Richard Javier Perez Cubas on 19 Dec 2017 06:25:17
It would be very useful if Power BI allow to export charts directly to excel without lose the format. Exporting just like values with format.
Administrator on 01 Apr 2024 05:47:37
We are looking at supporting this once Loop becoems available in Excel
- Comments (123)
- Merged Idea (2)
RE: Export charts directly to excel
Yes, so needed.Best regards,
RE: Export charts directly to excel
Really need this feature... as Report users needs conditional formatting to be retained on Excel data Export for further analysis.
It's critical things. Plz provide any interim or permanent solution
RE: Export charts directly to excel
Any updates on this?
RE: Export charts directly to excel
Power BI is an amazing solution that falls short in this area. Competing BI Tool exports products have been doing pixel perfect formatted exports well for many years. Why Power BI Table and Matrix Visualizations cannot export to Excel and retain the styles, fonts, formatting, colors. etc. is very perplexing as both products and the visualizations are all owned by Microsoft. Apparently this functionality is not on the roadmap. Microsoft should be leaders in this space. imo this shouldn't need to be voted on, please just put it on the roadmap for at least these two visualizations. Thanks.
RE: Export charts directly to excel
I implemented it using PowerBi embedded solution. My web app had a powerBi embedded report and returned the Excel pivot table, which look exactly like matrix, when users exported the data from matrix visuals to Excel. The web app took the exported data and built the Excel pivot table using ClosedXML nuget package.
RE: Export charts directly to excel
We use PBI to visualize student assessments and use colour to represent at or above grade level so we know where to direct resources. Exporting the tables to a spreadsheet with the colours makes for easy printing. This feature would be amazing!
RE: Export charts directly to excel
Agree. I need this feature for many reports to avoid rebuilding the exported tables in excel.
RE: Export charts directly to excel
Need this feature
RE: Export charts directly to excel
Exporting the format along with the underlying data will remove lot of manual works on excel after exporting .
RE: Export charts directly to excel
This is a must for lot of our customers. Ee cannot pre-format an excel sheet and connect it to the dataset because users apply filters and dig the data in power bi, then export it to excel for sharing results.