Forum Discussion
export visual data in excel
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
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.