Forum Discussion
How to export the PBI Visuals to excel?
Hi all ,Suppose we have 20 Visuals or more in a report, can we export the visuals from PBi to excel(editable ), not like png or pdf formats?
5 Replies
- TomMartens
Super User
Hey SIVAChitti ,
Unfortunately the answer is: No, this is not possible.
Regards,
Tom - AnonymousNot applicable
Hi SIVAChitti ,
Power BI cannot export all visuals to Excel in one go, and it cannot export visuals as editable Excel charts.
But you can export the underlying data behind each visual to Excel.
You can post feedback in Microsoft ideas forum.
https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas?
If my response as resolved your issue please mark it as solution and give kudos.
- v-echaithra
Community Support
Hi SIVAChitti ,
Thank you Anonymous , TomMartens for your inputs.I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!
Thank you
Chaithra E. - v-echaithra
Community Support
Hi SIVAChitti ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
- Olufemi7
Super User
Hi SIVAChitti,
Power BI doesn’t support exporting visuals themselves (charts, formatting, colors) into Excel as editable objects. What you can do is export the data behind each visual.
From a report visual, click the More options (…) → Export data.
Choose Summarized data (aggregated values shown in the visual) or Underlying data (raw rows, if permissions allow).
The export will give you an Excel (.xlsx) or CSV (.csv) file with the data, which you can then edit or use to rebuild charts in Excel.
Official Microsoft documentation: Export the data that was used to create a visualization
Limitations:
You need to export each visual individually; there’s no bulk export for 20+ visuals.
Only the data is exported, not the visual formatting.
Export permissions depend on how the dataset owner/admin has configured the report.
Alternative: If your goal is to work with all visuals’ data in Excel, use Analyze in Excel. This connects Excel directly to the Power BI dataset, so you can build PivotTables and charts without exporting each visual one by one.
In short: You can export the data behind visuals into Excel, but not the visuals themselves. For multiple visuals, Analyze in Excel is the recommended approach.