Forum Discussion

ldwf's avatar
ldwf
Helper V
3 years ago
Solved

Row Level Security using AD-ENT group

Hello, I have a PBI model and want to do Row Level Security.  I don't want to do this creating roles; instead I am hoping this can be done using AD groups.  We currently have one AD group that people...
Power BI Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    Hi ldwf ,

     

    Whether the advice given by d_gosbell  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


    Looking forward to your feedback.


    Best Regards,
    Henry

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi ldwf ,

 

The group that sets rls must meet the following conditions, and in addition what are the types of members in your group respectively?

related document:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ldwf's avatar
ldwf
Helper V
3 years ago

Thanks but I am looking for a solution that doesn't involve setting up roles.  I'm looking for a solution based on the AD Group the user is in. I am able to query AD but there are so many fields I don't see what field is the actual AD Group.  So if a user is in AD Group ABC, my Excel spreadsheet would indicate that Group ABC has an indicator value of 1, which means they have access to rows where the indicator value in the fact table is 1.  This way, I create a spreadsheet just one time containing the two AD Groups and the indicator column.  I incorporate this spreadsheet into the model and it's done.  it is based totally on the Active Directory group.  Thanks