Forum Discussion

SIVAChitti's avatar
SIVAChitti
New Member
9 months ago

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?
Need Help
Olufemi7's avatar
Olufemi7
Icon for Super User rankSuper User
9 months ago

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.