export visual data in excel

[powerbiexpert22]

can it be possible to export visuals data in excel format either from desktop or from service?

[Bibiano_Geraldo]

Hi @powerbiexpert22 ,

Yes, it's possible to export the data behind visuals in Power BI to Excel, whether you are using Power BI Desktop or the Power BI Service.

From Power BI Desktop

Select the Visual: Click on the visual whose data you want to export.

Export Data:

• Click the 3 dot menu (...) .
• Choose Export data.

From Power BI Service

Select the Visual: Hover over the visual and click on the three-dot menu (...).

Export Data:

• Choose Export data.

File Format:

• Choose Data with current layout or Summarized data or Underlying data, based on your access and data permissions.
• and click export

[powerbiexpert22]

Hi @Bibiano_Geraldo ,

there is no option to export visual data in excel format in power bi dektop

[Bibiano_Geraldo]

Hi, the csv files can be opened in excel:

Save in your desired folder, and open it in excel, and your data will look like this:

Now select the Column A, go to DATA, text to columns, delimited and next:

in next window, choose comma and finish:

And now, the data will be separed by columns instead of comma:

[powerbiexpert22]

Hi @danextian ,

I am not clear on what you mean by dimensions and columns , please share more details 

[Ajithkumar_P_05]

Yes, in Power BI, you can export visual data to Excel from both Desktop and Service by selecting More Options  → Export data

[powerbiexpert22]

Hi @Ajithkumar_P_05 ,

I am unable to finf option to export visual data in excel format in power bi desktop

[Laxmanjatoth]

1. Exporting Data from a Visual (Power BI Desktop and Service)
You can export the data underlying a visual (like tables, charts, or graphs) to Excel.

In Power BI Desktop:
Select the Visual: Click on the visual (chart, table, etc.) you want to export.
Export Data:
Right-click on the visual and select "Export Data".
You’ll be prompted to choose the format: either .xlsx (Excel) or .csv (CSV).
Save the File: Choose the location to save the exported file.
In Power BI Service (Online):
Open the Report: Navigate to the report containing the visual.
Export Data:
Click on the ellipsis (...) in the top-right corner of the visual you want to export.
Select "Export data".
Choose either .xlsx (Excel) or .csv format.

[v-achippa]

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

5. Select the export file format Excel (.xlsx) or CSV is available in the Power BI Service.
6. 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).

6. 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]

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]

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 · Accepted solution]

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]

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

[v-achippa]

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  to help the other members of the community find it more quickly. 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

[ribisht17]

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

[powerbiexpert22]

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

[ribisht17]

Hi @powerbiexpert22 

You can use multiple ways like this CSV to EXCEL Converter - FreeConvert.com 

Regards,

Ritesh

[skparavind_1994]

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]

Hi @skparavind_1994 ,

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

[ribisht17]

hi @powerbiexpert22 

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

[danextian]

Hi @powerbiexpert22 

It's possible only for the dimensions and columns added to the viz.