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

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

Instead of RLS, how about do not grant your report consumers access to the workspace, but instead grant them access to the specific reports for which you want them to have access

 

Create two security groups, (just for example, group_A, group_B), then share specific reports with group_A and other specific reports with group_B

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thanks for your answer blopez11  but i would like them to use the apps instead of workspaces in the end. since we have a premium capacity.