Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

export visual data in excel

can it be possible to export visuals data in excel format either from desktop or from service?
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi powerbiexpert22 

     

    As I mentioned in the above reply that Power BI Desktop primarily allows exporting data as a CSV file, which you can open in excel.

     

    If you specifically want to export data as an Excel file, follow below method:

    Save your report in Power BI Desktop and publish it to the Power BI Service

    Open the report in Power BI Service, and select “export data” from the visual and choose the file format Excel.

     

    Below is the image from Power Bi Service:

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

     

    Thank and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi powerbiexpert22 

Thank you for reaching out to Microsoft Fabric Community.

 

Yes, in Power BI, you can export the data behind visuals to Excel format, either from Power BI Desktop or Power BI Service. Below are the detailed steps for each environment.

 

PowerBi Service:

  1. Go to the Power BI Service and navigate to the report containing the visual.
  2. Hover over the visual and click the ellipsis (...) in the top-right corner.
  3. Select Export data from the dropdown menu.
  4. Select either:
  • Summarized data: Exports aggregated data as shown in the visual.
  • Underlying data: Exports the raw data (requires the dataset to allow this and permissions to access it).
  1. Select the export file format Excel (.xlsx) or CSV is available in the Power BI Service.
  2. Download and save the file.

Note:

  • In Power BI Service, the Underlying data option requires the dataset owner to enable this capability.
  • Power BI Service exports up to 150,000 rows in Excel format and 30000 rows in Csv format for summarized data.

PowerBi Desktop:

  1. Open your report and click on the visual you want to export data from.
  2. Click on the ellipsis (...) in the top-right corner of the visual.
  3. Select Export data from the dropdown.
  4. Choose Summarized data (default aggregation) or Underlying data (raw data behind the visual, if permissions allow).
  5. Select the export file format:
  • CSV (default for Power BI Desktop).
  1. Save the file.

Note:

  • In Power BI Desktop, the data is exported as a CSV file, which you can open in Excel.
  • Power BI Desktop exports up to 30,000 rows in CSV format.

Export Restrictions:

  • Some visuals may restrict exporting data due to size or dataset permissions.
  • Not all custom visuals support data export.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and Regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi powerbiexpert22, 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?

If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Thank you for being a part of the Microsoft Fabric Community Forum!

 

Thanks and Regards,

Anjan Kumar Chippa

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    1 year ago

    Hi v-achippa ,

    I am unable to find option in power bi desktop to export data in excel , it is giving me only csv option

     

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi powerbiexpert22 

       

      As I mentioned in the above reply that Power BI Desktop primarily allows exporting data as a CSV file, which you can open in excel.

       

      If you specifically want to export data as an Excel file, follow below method:

      Save your report in Power BI Desktop and publish it to the Power BI Service

      Open the report in Power BI Service, and select “export data” from the visual and choose the file format Excel.

       

      Below is the image from Power Bi Service:

       

      If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

       

      Thank and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi powerbiexpert22,

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. or let us know if you need any further assistance?

        Don't forget to give a "Kudos" – I’d truly appreciate it! 

         

        Thank you for being a part of the Microsoft Fabric Community Forum!

         

        Thanks and Regards,

        Anjan Kumar Chippa