cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samrawit21
Post Patron
Post Patron

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 @Samrawit21 ,

 

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

 

@v-deddai1-msft 

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

Hi @Samrawit21 ,

 

Have you check the settings mentioned by arvindsingh802 ?

 

Best Regards,

Dedmon Dai

arvindsingh802
Solution Sage
Solution Sage

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

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

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.