Hi, In PBI Report Server,
I need to give someone permissions to Manage Row Level Security on a report, but I don't want them to be able to manage the other Security for the report itself. I have tried putting them in a Security Role with the 'Set security for individual items' Task but this allows them to manage both Row Level Security and also the Security of who can access the report. This means they can remove the BuiltIn\Administrators from having access to the report. I'd like to prevent that while still allowing them to manage which of their users can see which rows of data.
How is this possible?
Thanks.
