Forum Discussion

Lucy01's avatar
Lucy01
Helper I
13 days ago

Row Level Security Errors

I have a report that is nearly ready to publish and I am trying to assign RLS so each team leader only sees their own team’s results. I’ve created an excel spreadsheet that records each team leader’...
Need Help
Praful_Potphode's avatar
Praful_Potphode
Super User
13 days ago

Hi Lucy01 

While testing RLS, did you select your role and Other user as well?

When we are testing locally for any dynamic rls role, we need to select role and other user.

in the other user , enter emailid you want to test like below.

 

 

If this doesn't solve the issue, let me know.

Please give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

 

Lucy01's avatar
Lucy01
Helper I
12 days ago

Thank you, yes I was selecting role, other user and entering the email address as you have shown and it is returning blank data so not sure what the issue is.

  • Praful_Potphode's avatar
    Praful_Potphode
    Super User
    12 days ago

    Hi Lucy01 

    Can you share data model diagram here.

    ideally TeamAccess should be disconnected table.

    Datasheet should be connected to other tables in the model.

     

    Please give kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

    • Lucy01's avatar
      Lucy01
      Helper I
      6 days ago

      Thank you, here is a mock up of the model view showing the different data tables. The Main Data Sheet contains the majority of information and the Second Data Sheet is a copy of the Main Data Sheet with the columns unpivoted. I appreciate that's probably a little strange, as is having a Calendar Table and a Date Table, but it was the only way I could find to process and present the data I have.

      The column names for Main Data Sheet and Second Data Sheet are the same, as are the access requirements for the Team Leaders.

      Below is also an example of how the UPN & Access sheet is laid out with the Team Leader's name, their Email/UPN and the Team they have access to.

      I appreciate any advice you can give me on how to set my row level access so that Team Leaders see the data from their teams only. Thank you

      • Praful_Potphode's avatar
        Praful_Potphode
        Super User
        5 days ago

        Hi Lucy01​ 
        below observations from the modeling.

        1. Main Data Sheet and Second Data Sheet seems to have same columns.try to combine them into one single fact table.if you have column difference between the two you can still append them into one fact table.
        2. Try to have one single date table which will cater to all date and time period calculations.
        3. Connect UPN Access table to fact table.

        Redesign your model as per below diagram:

        Your RLS will flow like below:

        this will be optimized version which will not create issues in longer run.

        Please give kudos or mark it as solution once confirmed.

        NOTE: both diagrams were generated using LLMs.

        Thanks and Regards,

        Praful