cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

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.

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.

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Teams workgroup as RLS filter in Power BI

Hi @wzkoral 

 

You need a dynamic RLS to your report for different clients.  Below are the references for desktop and serivce.

 

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/desktop-rls

 

Best Regards,
Kelly

Highlighted
Advocate II
Advocate II

Re: Teams workgroup as RLS filter in Power BI

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.

Highlighted
Community Support
Community Support

Re: Teams workgroup as RLS filter in Power BI

Hi @wzkoral

 

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

 

Annotation 2020-02-18 164131.png

 

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!
 
Highlighted
Advocate II
Advocate II

Re: Teams workgroup as RLS filter in Power BI

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors