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?

5 Replies

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity 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's avatar
    v-echaithra
    Icon for Community Support rankCommunity 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.

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