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
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
Hi Bibiano_Geraldo ,
there is no option to export visual data in excel format in power bi dektop
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: