Reply
mikecrobp
Helper I
Helper I

What permissions are required to Export to Excel in the Service

We have published reports where some users need to export to Excel - both the data with current layout and underlying data.

However we also have users where we want to restrict that ability - is that possible?

Also - is it possible as an admin to "impersonate" a user to test you got it right?

 

This article seems to suggest that you need Build Permission for the dataset in order to Export to Excel - but I am not sure that is addressing my scenario

Build permission for shared datasets - Power BI | Microsoft Learn

1 ACCEPTED SOLUTION

Hi @mikecrobp ,
You need to have build permission for the dataset before you can export data from a visual of that dataset
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

4 REPLIES 4
avatar user
Anonymous
Not applicable

Hi @mikecrobp ,

1. You could assign specific user with view permission to restrict export underly data to excel.

2. There in no way that an admin to "impersonate" a user to test, need login in different Power BI account in Power BI Service Portal to test it.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pratyashasamal
Memorable Member
Memorable Member

Hi @mikecrobp ,

If you do have permissions to the data, you can see, and export the data that Power BI uses to create a visualization. You needs to do these steps to enable export :-

  1. Start in Power BI Desktop.

  2. From the upper left corner, select File > Options and Settings > Options.

  3. Under CURRENT FILE, select Report settings.

  4. Make your selection from the Export data section. ("

    • Allow end users to export summarized data from the Power BI service or Power BI Report Server")

You can also update this setting in the Power BI service.

It's important to note that if the Power BI admin portal settings conflict with the report settings for export data, the admin settings will override the export data settings.
For more information refer to this link :-
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-s...
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Sorry (and thank you) - I should have been more explicit. I have enabled "export urrent layout and underlying data"

What I want to do now is make it so that some users (ie with some permissions) can export but others cannot

Hi @mikecrobp ,
You need to have build permission for the dataset before you can export data from a visual of that dataset
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)