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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Issue in export Data

Hello,

I have a report in power BI server with a table-type visual object and I want to export to excel when exporting data only allows summary data to be exported, I get the following message:

 

mzambrano866_1-1677093782792.png

 


How can I unlock the other options to export data with current or Underlying data.

 

3 REPLIES 3
sevenhills
Super User
Super User

I believe you are talking Power BI .pbix report. (and not the .rdl type report). If yes, you need to change the setting. Two ways to do it

 

a) Using Power BI Desktop:

The link is provided here, same link in your posted image.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

section:  Admin and designer controls for exporting

 

In Power BI Desktop, Check the option and republish the report and see

"Allow end users to export both summarized and underlying data ... "

 

sevenhills_0-1677188239002.png

 

 

b) Power BI Workspace, right click the interactive report, settings, export data section, select as below:

sevenhills_1-1677188459127.png

 

Hope this helps!

Anonymous
Not applicable

Hello,

 

Thanks for your reply but I have done this. Then I re-upload the report to power bi server but the error persists.

These are the two options, which I am aware of.

 

Once you re-uploaded the report, can you check on Power BI Service? 

 

Power BI Workspace,

right click the interactive report you re-uploaded,

settings,

export data section,

check export data is "Summarized data, data with current layout and underlying data"

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.