Forum Discussion
Export Underlying Data - User getting Permissions Denied
I have a couple of reports in Power BI that I want the end-users to be able to export the underlying data for what I am showing in my visual. I have the report set to allow for the export of underlying data and myself and a couple on my team are able to do that without a problem but the majority of my end-users get a permission denied message. The only thing I can think of is those of us who can do this without a problem are global admins on our Office365 tenet while the rest are not. I am trying to find any other setting to enable or change to make this work but I have been unsuccessful. Any ideas on what I am missing?
Thanks.
Hi Anonymous
If the others on your 365 tent can export the visual data ,that means there is no problem with the settings of the export function . At this time, you have to consider whether end users have permission to access your report .
(1)If the end users don’ t have Pro license or your report is not in the premium capacity ,they may not export the underlying data .
(2)If you share the report without “build” permission, end users cannot export the underlying data also .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hey Anonymous ,
if you can or cannot export the underlying data depends if the user has build permission:
Build permission for shared datasets - Power BI | Microsoft Docs
The permission can be set by user individually or by AD group. So in your case the non admin user might not have build permission and then cannot export the data.
Also be aware that you can disable the export in the report itself:
So you might have to check both options.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicI do have the same denied access issue when trying to export using "Underlying data", please check the following settings from Setting from PowerBI desktop.
I selected "Allow end users to export both summarized and underlying data from the service or report server" from powerbi desktop and also verified in the PowerBI server, it is displayed as "Summarized data and underlying data" under Export data. But still user is not able to select the underlying data while trying to export. Please let me know what might be the issue.
Also i do have multiple pages and only one page is not working "Underlying data" export. Other pages i can select the underlying data and worked fine.
Hi Anonymous
If the others on your 365 tent can export the visual data ,that means there is no problem with the settings of the export function . At this time, you have to consider whether end users have permission to access your report .
(1)If the end users don’ t have Pro license or your report is not in the premium capacity ,they may not export the underlying data .
(2)If you share the report without “build” permission, end users cannot export the underlying data also .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
