Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

row level security see all

Dear all,   I have a workspace, with multiple reports, i want some reports to be seen by group A and some to be seen by group B. Although you cant hide the report for one another, i can make the r...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    RLS is aimed at data row level filtering. It filters datasets rather than specific reports according to the established role rules.

    If you just want some reports to be seen by group A and some to be seen by group B,it is recommended to use blopez11's workaround.

    For your instance,if you want  user in  group B can only see all data in ReportB,you need to create a role, filter ReportB related table by enter a dax expression that return "True" and filter out other tables that are not related to ReportB by entering a dax expression that returns "False".

    For example:

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

RLS is aimed at data row level filtering. It filters datasets rather than specific reports according to the established role rules.

If you just want some reports to be seen by group A and some to be seen by group B,it is recommended to use blopez11's workaround.

For your instance,if you want  user in  group B can only see all data in ReportB,you need to create a role, filter ReportB related table by enter a dax expression that return "True" and filter out other tables that are not related to ReportB by entering a dax expression that returns "False".

For example:

 

Best Regards,
Community Support Team _ Eason