Forum Discussion

AlexRowl's avatar
AlexRowl
New Member
2 years ago
Solved

RLS in enterprise workspace

Hi,   I have a report created based on D365FO data consolidated into a SQL view. It has a field called RLS that contains a department and legal entity as that is the toggle for security in this cas...
Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi AlexRowl 

     

    RLS will not work if someone is a member of a workspace. 

     

    • Remove everyone who isn't developing reports in that workspace
    • In The workspace click on the 3 dots beside the dataset name and choose security
    • You will see the roles on the left and the option to add an email address or a security group. The users who are entered here will be subjected to the RLS rules, others shoudln't see anything

     

    Thanks

    Joe

Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi AlexRowl 

 

RLS will not work if someone is a member of a workspace. 

 

  • Remove everyone who isn't developing reports in that workspace
  • In The workspace click on the 3 dots beside the dataset name and choose security
  • You will see the roles on the left and the option to add an email address or a security group. The users who are entered here will be subjected to the RLS rules, others shoudln't see anything

 

Thanks

Joe

AlexRowl's avatar
AlexRowl
New Member
2 years ago

Hi Joe, Thank you very much for the response, I really appreciate it. I have now got this working.

 

So I did need to keep the user as a viewer within the workspace. If I did not then I got the below.

 

However, I added the user into the security section of the semantic model and now they are subject to the RLS and can view the report but not the content that was not applicable.

 

Thanks

Alex