Forum Discussion
DRLS with Azure AD
Hi,
I am trying to implement DRLS in Power BI based on Security Groups created under Azure AD.
But unfortunately, I cannot see these AAD based security groups in Power BI service (Add users or groups option), however, I can see all other groups which exists on On-prem Windows server.
Question: Is it possible to use Azure AD in RLS or only AD are allowed?
1) AAD group
2) Power BI Service
Thanks
Ritesh
3 Replies
Hi riteshgaurtyser ,
You can create security groups on O365 admin center: Create, edit, or delete a security group in the Office 365 admin center. Then add all users into corresponding security group. Add security group you want to add to the role.You cannot add Groups created within Power BI. You can add members external to your organization.
You can also refer to https://community.powerbi.com/t5/Service/Row-level-security-for-more-than-1000-users/td-p/459475
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks Dedmon,
After following your suggestion, I can now see the AD created in O365 in Power BI Services.
But, I am not able to resolve the issue where I want to Active Directory connection in Power BI Desktop, it comes with follwoing error (in screen shot)
Thanks
Ritesh
Hi riteshgaurtyser ,
Would you please follow the steps in https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/ to connect to AD?
If this post helps, please consider accept it as the solution to help the others find it more quickly.
Best Regards,
Dedmon Dai
