cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JasonStinnett
New Member

RLS works when I add People, errors for AD Group

Hello,

I've created up a report using RLS. The filter is set up in desktop based on USERPRINCIPALNAME(). 

 

When I go into the service and add an individual person as a member of the role, everything works correctly.

 

If I remove that individual, and instead add the AD Group that they belong to as a member, then they are able to open the report but all visuals display the following error:

 

visual-contains-restricted-data.jpg

 

My goal is to use RLS to filter data at individual user level, without having to manage users one at a time for each and every data set. I found a number of forum posts that indicate adding groups as members solves this problem.

 

Is there perhaps some issue with the Azure AD group setup? My IT admin handled this step, and I wasn't able to find much documentation.

 

Thanks!

Jason

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: RLS works when I add People, errors for AD Group

Hi @JasonStinnett ,

 

Could you please check what is kind of group in Azure AD you are trying to assign with the roles of RLS? Based on this documentYou can add a member to the role by typing in the email address, or name, of the user, security group or distribution list you want to add. You cannot add Groups created within Power BI

 

Based on my test, it works fine with the Serucity group created in Azure AD.

 

7.jpg8.jpg9.jpg10.jpg11.jpg

 


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: RLS works when I add People, errors for AD Group

Hi @JasonStinnett ,

 

Could you please check what is kind of group in Azure AD you are trying to assign with the roles of RLS? Based on this documentYou can add a member to the role by typing in the email address, or name, of the user, security group or distribution list you want to add. You cannot add Groups created within Power BI

 

Based on my test, it works fine with the Serucity group created in Azure AD.

 

7.jpg8.jpg9.jpg10.jpg11.jpg

 


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

JasonStinnett
New Member

Re: RLS works when I add People, errors for AD Group

Hi Dong Li @v-lid-msft ,

Appreciate your help. It was an issue with the security group setup.

 

What is the best way to add all users to a security group?

 

It works when we add individual users to the security group, but we'd like to give everyone access without having to add users one at a time.

Thanks,
Jason

Community Support
Community Support

Re: RLS works when I add People, errors for AD Group

Hi @JasonStinnett ,

 

Based on this document, We can Using Azure Active Directory (Azure AD) portal to add a large number of members to a group by using a comma-separated values (CSV) file to bulk import group members.

 

1.jpg

 


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
JasonStinnett
New Member

Re: RLS works when I add People, errors for AD Group

That should work, thanks again for all your help Dong Li!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications