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

ribisht17's avatar
ribisht17
Super User
1 year ago

hi  

Yes, it is possible to export Power BI visuals data to Excel from both Power BI Desktop and the Power BI Service. Here are the steps for each:

Power BI Desktop:

  1. Open your report in Power BI Desktop.

  2. Select the visual you want to export.

  3. Click the ellipsis in the top right corner of the visual.

  4. Select "Export data" from the dropdown menu.

  5. Choose the format (CSV or Excel) and click "Export".

  6. Download the file to your local machine.

    Power BI Service:

    1. Open your dashboard in the Power BI Service.

    2. Click on the visual you want to export.

    3. Click the ellipsis  in the top right corner of the visual.

    4. Select "Export data" from the dropdown menu.

    5. Choose the format (CSV or Excel) and click "Export".

    6. Download the file to your local machine.

   Regards,

   Ritesh

   Please mark the answer as helpful if it was useful, so that it can assist others as well ✔️

   Dance-Sing with Data Projects - YouTube

  • skparavind_1994's avatar
    skparavind_1994
    Frequent Visitor
    1 year ago

    In addition to, kindly note that 
    In Power BI Desktop, only 30000 rows we can export as excel.
    In Power BI service, we can export data with current layout (1,50,000 rows max) and with summarized data with live connection you can export (500,000 rows max).

    • powerbiexpert22's avatar
      powerbiexpert22
      Impactful Individual
      1 year ago

      Hi skparavind_1994 ,

      I do not see any option in power bi desktop to export data in excel format

  • ribisht17's avatar
    ribisht17
    Super User
    1 year ago

    hi powerbiexpert22 

     

    Thanks for the thumbs up , you can mark it as a solution so that it can help others as well 

     

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    1 year ago

    Hi ribisht17 ,

    I am unable to find option to export visual data in excel format in power bi desktop, it is only giving me csv option in drop down while saving the file