DRLS with Azure AD

[riteshgaurtyser]

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

[v-deddai1-msft]

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... 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

[v-deddai1-msft]

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

[riteshgaurtyser]

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