Forum Discussion

dpollozhani's avatar
dpollozhani
Helper I
4 years ago

Bad performance RLS for non-admin users: what can be done?

Hi all!   I believe I have an RLS performance problem and hope someone can help.   Users subject to RLS are experiencing very long waiting times for simple actions like expanding the hierarchy of...
Data Protection
Need Help
GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi dpollozhani 

 

I am going to assume that is those other tables with the calendar and item which are causing the issues. I have had large models over 50GB in size with many RLS roles that perform really fast. Which to me would indicate that it has to do with the way your data is modelled which is causing the performance issue.

 

I was also with the understanding that the RLS is applied when the user logs in (And why my models perform really fast). It would come down to the DAX having to evaluate the calendar and item table when they are used in the DAX measures or columns put into visuals

  • dpollozhani's avatar
    dpollozhani
    Helper I
    4 years ago

    Perhaps you are right, and I might have to try removing those snowflakes just to test.

     

    The calendar snowflake is however something I need because it solves a specific issue. The item snowflake is in all honesty unneccessary, just due to me not having bothered joining the tables beforehand.

     

    Regarding your fast performing models with RLS, have you also had this natural M:M relationship between Facts and RLS like I do?