Forum Discussion
Resolver Icopy database permissions / app permissions / row level security
Hi there
At the moment we are running a pilot group of 40-ish people with PowerBI reports.
We have 3 different apps and a number of reports and datasets.
For every one of them we have a list of database permissions / app permissions / etc. (see the screens below).
Now it is already annoying to add everyone for all databases, but when we go live with 500ish users, it becomes a straightforward nightmare.
How can we best maintain this? Alternatively. can we copy/paste security/permission lists?
Regards
DP
Hi denpries,
I don't think there is an option to directly copy/paste security/permission lists currently.
In your scenario, I would suggest you try using dynamic row level security, instead of creating separate roles. Following are some good articles/blogs about Dynamic Row Level Security with Power BI for your reference. :smileyhappy:
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
Regards
1 Reply
v-ljerr-msftMicrosoft Employee
Hi denpries,
I don't think there is an option to directly copy/paste security/permission lists currently.
In your scenario, I would suggest you try using dynamic row level security, instead of creating separate roles. Following are some good articles/blogs about Dynamic Row Level Security with Power BI for your reference. :smileyhappy:
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
Regards