Forum Discussion

syasmin25's avatar
syasmin25
Helper V
6 years ago

Row Level Security

Hello, 

I am trying to implement Row level security into one of my reports and wanted some advice regarding a problem that I am currently facing. I have a table with different departments purchases (based on the data from a survey) so that would contain Department Name, Employee First Name and Last Name, Products, Price. And my second table has "Usernames" for each departments, Department Name, ID and Email address. 
I connected both the tables using their Department Names ( it is a Many to one relationship).And everytime I try to click on the "Apply security filter in both directions", I get the following error:




My DAX expression from the second table to make the row level security work is:

And it works perfectly when I try to view as using different IDs in the Power BI Desktop, However my report looks completely blank on the server whenever I try to test out a role. Can someone please tell me what am I doing wrong here?
Any assistance would be greatly appreciated.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

    • syasmin25's avatar
      syasmin25
      Helper V
      6 years ago

      It is just different views depending on the department viewing the report ( Accounting, Purchasing, Sales, etc.). The head of each department would be able to view the report based on their username. The report is basically for managers of different departments.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  syasmin25 

    It should works well, Please try to enter a user in here to test the rls in power bi service:

    and you'd better use another account to test it again.

     

     Warning

    If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

     

    Regards,

    Lin