Teams workgroup as RLS filter in Power BI

Question

HiHow to use Teams Worgruop name to RLS Filter Power Bi raport published in this Teams gruopWe have group for every big client and we want to have filtered to only this client data raport shown.We have one raport os whole sale with RLS to Key Acount level , but now we want to deeper with filtering .We share this raport with link and in link is added filter with client number and it was working until update of Teams. Link is fine and worki but u have click link it dosent star in Teams.

v-kelly-msft · Answer

Hi wzkoral&nbsp;&nbsp;You need a dynamic RLS to your report for different clients.&nbsp; Below are the references for desktop and serivce.&nbsp;https://docs.microsoft.com/en-us/power-bi/service-admin-rlshttps://docs.microsoft.com/en-us/power-bi/desktop-rls&nbsp;Best Regards,Kelly

wzkoral · Answer

But i need to get the MS Teams workgroup name. Not workgroup with I specife by my self in the table.

wzkoral · Answer

I know and we already have dynamic RLS with userprincipalname() DAX function. But we need anather dynamic filter by User group in Teams.

One person have few clients and in specyfic client workgroup raport should shown only data for that person and that client .
That why we are looking how to read workgroup name from teams to Power BI , rest to do RLS with it its easy.

v-kelly-msft · Answer

Hi wzkoral ，&nbsp;First,you need to create a group table,such as below:&nbsp;&nbsp;Then make a definition about each group returns what kind of value.For the reference,you can turn to the blog here.&nbsp;Best Regards,Kelly&nbsp;Did I answer your question? Mark my post as a solution!&nbsp;

Forum Discussion

Teams workgroup as RLS filter in Power BI

4 Replies

Related content

Activator Teams Alert

Setting up Microsoft Teams and Outlook 365 Connections

Team coverage calculations

Bug with Activator Teams bot

Filter