Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Export underlying Data to Excel

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.

7 REPLIES 7
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please also check the settings of report:

Capture36.PNG

 

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
Not applicable

@v-deddai1-msft 

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

Hi @Anonymous ,

 

Have you check the settings mentioned by arvindsingh802 ?

 

Best Regards,

Dedmon Dai

arvindsingh802
Super User
Super User

Please make sure export enable in your report 

arvindsingh802_0-1624358340712.png

as well as on your Power BI Admin Portal

 

arvindsingh802_1-1624358374546.png

 

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


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
Anonymous
Not applicable

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

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


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors