Export underlying Data to Excel

[Anonymous]

Hi, Export underlying and summarized data option is selected. Still, when I try to export the data, the Export the underlying data option is disabled, and it says currently underlying data can only be exported into an Excel doc(.xlsx).

In the File format, only .csv format is available. I have excel version 2015 installed on my windows computer.

[v-deddai1-msft]

Hi @Anonymous ,

Please also check the settings of report:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

@v-deddai1-msft 

Yes, in the report settings, Export Summarized data and underlying data option is selected.

[v-deddai1-msft]

Hi @Anonymous ,

Have you check the settings mentioned by arvindsingh802 ?

Best Regards,

Dedmon Dai

[arvindsingh802]

Please make sure export enable in your report 

as well as on your Power BI Admin Portal

Once enabled you would be able to export data.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal#export-data

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#set-the-export-...

If this post helps, then please consider Accept it as the solution and give it a thumbs up

[Anonymous]

@arvindsingh802 @v-deddai1-msft 

Yes, Export both Summarized data and the underlying data option is selected, but I can only export the summarized data to .csv files.
Export the underlying data option is disabled, and it says currently underlying data can only be exported into an Excel doc(.xlsx).

I can export the summarized data, but only to the .csv file format.
Even for the summarized data, export to .xlsx file format is not available.

[arvindsingh802]

Are you trying to export the data from Power BI desktop or Web ?

[Anonymous]

@arvindsingh802 I am trying to export data from the Power BI service.