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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
HBMIRA
Frequent Visitor

You don't have permission to export underlying data

Hello,

 

I have a dataset hosted in service. Users using that datasource cannot export underlying data to excel. The box for exporting underlying data is grayed out and the message pops up that they do not have permission to export that underlying data. I've followed instructions from older posts regarding this issue but still cannot get this feature enabled. The dataset was set so users could only export summarized data but after changing it to allow for exporting underlying data the users still can only export summarized data.

 

Things I've tried so far. I republished the dataset (twice) with the checkbox for "Allow end users to export both summarized and underlying data from the service or Report Server" checked and users still cannot export underlying data. I've even redownloaded the pbix file from service to verify that the checkbox is still checked. The security settings in the service admin portal allow for exporting data (this setting was not changed) after these changes users can still only export summarized data. I've also tried refreshing the data but this doesn't change anything.

 

Is there anything else I should do to try to make it so users can export underlying data?

 

 

Thank you

1 ACCEPTED SOLUTION

Hi , @HBMIRA 

Have you checked it "Allow end users to export both summarized and underlying data from the service or Report Server" at all three points ?

desktop:

1.png

service:

 

2.png

 

admin tenant settings:

3.png

 

If so,pls consider power-bi-visualization-export-data#limitations-and-considerations

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
HBMIRA
Frequent Visitor

I want to add that the users have "build" permissions for the dataset.

Hi , @HBMIRA 

Have you checked it "Allow end users to export both summarized and underlying data from the service or Report Server" at all three points ?

desktop:

1.png

service:

 

2.png

 

admin tenant settings:

3.png

 

If so,pls consider power-bi-visualization-export-data#limitations-and-considerations

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you,

 

my issue was that it wasn't set per each report in service.

 

I was able to go into the workspace and then enable underlying data export per each report.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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