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!

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi dcheng029 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
      If you have any question relating to the current thread, please do let us know and we will try out best to help you.


      Thank you.



      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi dcheng029 ,

        We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

        If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
        If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

        Thank you!