Forum Discussion

acanepa's avatar
acanepa
Resolver I
8 years ago

RLS + Active Directory

Hi,   Is there a way to connect teams created inside Office with PowerBI RLS? In other words, applied security to different teams inside an organization? As company, we use Outlook as an email solu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

acanepa You could associate a security group to a role and apply permissions to the role. Otherwise if there are varying degrees of access you may need a permissions table in your model to regulate the filter context.

RLS does not work yet for the new "Hide Tabs", although I know MSFT was expecting the question :)

acanepa's avatar
acanepa
Resolver I
8 years ago

Hi Anonymous

 

Thanks for the answer. Is it possible to combine those security groups with this solution of Dynamic RLS?

 

https://community.powerbi.com/t5/Community-Blog/Power-BI-Dynamic-Row-Level-Security-Tips-to-get-it-working/ba-p/76865

 

Also, what is the best practice for creating security groups? Let's say I have a marketing team, where there are marketing executives and a marketing manager, so I have 2 security groups inside one team. Also, employees come and go, so members of the team are constantly changing. Is there a solution where I can have multiple security groups inside one team, without changing the team members? (AD updates the team members automatically).

 

It's possible that I'm wrong in some assumptions.

 

Regards,