Forum Discussion

dcheng029's avatar
dcheng029
Helper II
1 year ago
Solved

How to set up a bulk and dynamic RLS permissions list?

Hi everyone,   I have a published Power BI dashboard that contains sensitive and confidential information that only a select cohort of staff within the business should have access too.    Quick r...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Maybe.  Dynamic RLS requires the presence of an email address that you can then compare against USERPRINCIPALNAME().  If your SFDC Objects data source can provide that list of email addresses then you can use that to control the dynamic RLS.

     

    NOTE:  SFDC management chain changes are notoriously sluggish.  Make sure you don't accidentally expose data to users that have recently changed managers.

lbendlin's avatar
lbendlin
Super User
1 year ago

Maybe.  Dynamic RLS requires the presence of an email address that you can then compare against USERPRINCIPALNAME().  If your SFDC Objects data source can provide that list of email addresses then you can use that to control the dynamic RLS.

 

NOTE:  SFDC management chain changes are notoriously sluggish.  Make sure you don't accidentally expose data to users that have recently changed managers.

dcheng029's avatar
dcheng029
Helper II
1 year ago

Hi lbendlin thanks for the pointers, will check this out!