End user unable to export "underlying" data

[pborah]

I'm a workspace admin and I've given a test user access to the test workspace. His role has been set to "Viewer" in workspace access settings. I have enbabled export of "summarized" and "underlying" data for the report.

However the test user is unable to click-select the option for exporting "underlying" data even though he can see it when selecting the option to export.

I've been able to recreate this issue with other test users as well today. Documentations say anyone who has access to the workspace has access to the report as well as data although depending on their assigned role they may or may not be able to make any changes to the dataset or report. However I couldn't find anything that says their access level "role" will have anything to do with their ability to export summarized or underlying data behind a visual. 

I contacted the "Power BI" admin to see if this is a setting for our instance as a whole but he couldn't seem to find any such setting in the admin portal either. Any suggestions? Thank you.

[GilbertQ]

Hi @pborah 

That is just from my experience of working with Power BI and how it has worked for me in the past.

With regards to having it work for you I would suggest the only option is to vote for the idea at https://ideas.powerbi.com

[GilbertQ]

Hi @pborah 

I think that what happens is that when a person has a viewer role they can only export summarized data.

What happens if you change the users role to contributitor are they able to also export the underlying data?

[pborah]

Thanks @GilbertQ . That's good to know but can you explain whats the rationale behind that? I haven't found that info anywhere in the documentations I've read so far.

As an internal organizational policy, the end users will always be "Viewers" and their access won't ever be elevated to a "Contributor" unless specifically authorized as a one-time thing by upper management due to the highly sensitive nature of data we deal with. This specific report is meant for heads of certain departments and we are testing it with a handful of people who report to those heads, one of whom is an "analyst" let's say, before pushing it out to production. This analyst wants the ability to export the underlying data and make his own stuff in excel or his local copy of Power BI desktop since he doesn't have a Pro license. We have no problem with him exporting a snapshot of the underlying data specific to a visual, however he cannot have access to the entire dataset/datasource to make any changes on service. I hope I was able to explain properly.