Forum Discussion
Export To Excel Permissions With Security Groups but Splitting Out those Not Requiring Export
Good Morning
Hope someone can help please
I have a PBI report pubished to our Premium Workspace. Currently the users are in a Sercurity Group (as there are quite a few of them) The report originally did not require export to excel therefore this was disabled in report settings. I now need to enable this setting but for only a few of the users.
My question is,
- if I enable this in report settings to allow export to Excel and republish the PBIX file to the workspace,
- remove those requiring export permissions from their existing security group
- create a new one (splitting the users out)
- Give the new security group build permissions (keep build disabled for the original security group that export is not required)
will the security group without build permissions be able to export too. Or would you advise creating a new workspace and adding a copy of the report with export permissions to that workspace and assign the new security group to that workspace
Hope this makes sense
Thanks for your help
Kind regards
Karen
2 Replies
- amitchandak
Super User
KarenFingerhut , You have an option in the tenant setting, where you can give permission to the group to export
- KarenFingerhut
Responsive Resident
Hi amitchandak
Thanks for your reply
Yep already got that enabled and have some security groups in there.
So do the following
- 2 x security groups. One where I want them to be able to export and the other with those not wanting to export.
- Add the security group wanting to export to the setting, export to excel config
- Enable export permissions in the PBIX file and publish
This then means only the security group added to tenant settings can export?
Just need to ensure i'm doing it correctly.
Appreciate your help.
Kind regards
Karen