Forum Discussion

wzkoral's avatar
wzkoral
Icon for Advocate II rankAdvocate II
6 years ago

Teams workgroup as RLS filter in Power BI

Hi How to use Teams Worgruop name to RLS Filter Power Bi raport published in this Teams gruop We have group for every big client and we want to have filtered to only this client data raport shown. ...
Need Help
wzkoral's avatar
wzkoral
Icon for Advocate II rankAdvocate II
6 years ago

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's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi wzkoral ，

 

First,you need to create a group table,such as below:

 

 

Then make a definition about each group returns what kind of value.

For the reference,you can turn to the blog here.

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
 
  • wzkoral's avatar
    wzkoral
    Icon for Advocate II rankAdvocate II
    6 years ago

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