Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue with Row Level Security

Hello,   I have an issue in setting up a raw level security for my report. In my report I want to set a raw level security so each company can only see its sales in the report. Therefore, I created...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you all for your recomendations. However, the only way to give solution to this issue is to create a Dynamic RLS that solves the problem.

blopez11's avatar
blopez11
Icon for Super User rankSuper User
5 years ago

It would be easier to provide help if you could send screenshots of the following:

- your model, as it pertains to RLS

- roles setup in Power BI Desktop, showing role name and table

- DAX expression setup for each role

 

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello blopez11,

     

    Thanks for your response, unfortunately I cannot provide any screenshots I can however provide some of the information you require.

     

    Regarding DAX expression and table names for each role:

    I have settled static RLS assigning the roles using the Company name field (i.e. Role1: Company Name="Company1" gained from Companies table. This works fine. When I go for group of companies I create a similar role (i.e. Group of Companies Name="Group of Companies1" gained from Group of companies table, but this does not work as everybody with no access can still see this group of companies.

     

    Regarding the model please see below the structure