Forum Discussion
Global changes to Security roles
I use security roles to manage access to PBI reports. For example, a filter on SalesRepName, such as SalesRepName="Fred"
I have multiple reports (pbix files).
If a the SalesRepName changes from "Fred" to "Sam", is there a simple way of updating all PBIX files?
Failing this, is there a way to maintain these Secirity Roles in their own pbix, and then assign in some way to various different report sets. That way a change in the master would change all the different report sets.
Thanks, Phillip
Hi pntlindsay ,
RLS is divided into dynamic and static two types. What you describe is static RLS, you can try dynamic RLS. You can also directly add or delete roles in the security options in Power BI Service.
Reference: What Do You Need to Implement Dynamic Row-Level Security in Power BI?
Dynamic Row Level Security with Power BI Made Simple
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi pntlindsay ,
RLS is divided into dynamic and static two types. What you describe is static RLS, you can try dynamic RLS. You can also directly add or delete roles in the security options in Power BI Service.
Reference: What Do You Need to Implement Dynamic Row-Level Security in Power BI?
Dynamic Row Level Security with Power BI Made Simple
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.