Forum Discussion
Dynamic Row Level Security
Currently RLS Implemented and Page level Security Implemented by Maintaining 3 Tables (Basis User Type) in Power BI Layer. So when ever New User is to added/removed, I amk making changes in pbix file's tables --> Republishing --> Adding Users in service Account -->refreshing it in service.
It involved multiple steps actually which now end customer doesn't like.
So now i am actually checking some alternate options where Users Access can be enabled/desabled in one Click only from Power BI Service account.
Pls help someone on this, how can this be achieved?
Hi avishek287 ,
If you have the email account on the user table then you can just use the USERPRINCIPALNAME on your RLS without the need to add the uses manually on the service account.
1 Reply
- MFelixSuper User
Hi avishek287 ,
If you have the email account on the user table then you can just use the USERPRINCIPALNAME on your RLS without the need to add the uses manually on the service account.