Dynamic Row Level Security

[avishek287]

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?

[MFelix · Accepted solution]

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.

https://www.youtube.com/watch?v=jphj40tBPD8