Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Does Power BI RLS support MS Teams group

Hi,

 

Is it possible to add a MS Teams grouping to RLS role as shown below? Pls kindly help. Thks!

 

MeiWah_0-1645020924857.png

 

1 ACCEPTED SOLUTION
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @Anonymous 

Sorry but I think the answer is no.

You can use the following groups to set up row level security.

  • Distribution Group
  • Mail-enabled Group
  • Security Group

Note, however, that Office 365 groups are not supported and cannot be added to any roles.

As Teams groups are Office 365 groups that means they can't be used in RLS.

 

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

 

Hope this helps

Stuart

View solution in original post

5 REPLIES 5
christobo
Regular Visitor

Why is this not possible?

would also like to understand the reasoning.. duplicating the 365 groups to something else does not seem best practice to me

Burningsuit
Resident Rockstar
Resident Rockstar

Hi @Anonymous 

Sorry but I think the answer is no.

You can use the following groups to set up row level security.

  • Distribution Group
  • Mail-enabled Group
  • Security Group

Note, however, that Office 365 groups are not supported and cannot be added to any roles.

As Teams groups are Office 365 groups that means they can't be used in RLS.

 

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

 

Hope this helps

Stuart

@Burningsuit your answer is 100% accurate. But I am wondering how is that an acceptable situation knowing that MSFT is pushing, with good reason) the use of M365 Groups everywhere else? Dynamic Microsft 365 Groups drive most of our groups, permissions, sharing, ... but cannot be used in this situation.

 

Then, what is the strategy going forward? Is it to duplicate all M365 Groups with corresponding Security Groups? With nesting?

 

Any recommendation from Microsoft would be welcomed.

 

Thanks,

Jad

I'd like to know as well the reason why Microsoft 365 (formerly Office 365) groups are not supported in RLS or in giving direct access to reports.

 

What's frustrating is that it's already possible to add Microsoft365 groups for Power BI App audiences, but this is useless if the same groups can't also be used for RLS.

There seems to be a suggestion for this idea since 2019 but it barely has any upvotes. Please upvote so Microsoft can see it! https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=da3e0337-716f-4444-9718-0d82648a68fd

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors