Dynamic Row Level Security in Power BI with Exclude and Include rules

Question

Hi Team,&nbsp;Can you please help me how can i create Dynamic Row Level Security in Power BI with Exclude and Include rules based on multiple columns?Based on the below table I need to create Dynamic RLS.EmailsSBGSBU&nbsp;SBU excludesSBE excludesRegionCountryJoB Function exclude&nbsp;mary.arevalo@honeywell.comPMTHPS&nbsp;&nbsp;&nbsp;&nbsp;HR /HRC/CEO&nbsp;Matthew.Wald@Honeywell.comALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HR /HRC/CEO&nbsp;Rebecca.Zborowski@Honeywell.comALL&nbsp;ALT/HR&amp;CNTES/MSFS&nbsp;&nbsp;HRC/CEO&nbsp;Annie.Chmielewski@Honeywell.comHBT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HR /HRC/CEO&nbsp;Shannon.Felix@Honeywell.comHCE&nbsp;&nbsp;&nbsp;&nbsp;IndiaHR /HRC/CEO&nbsp;AUBRY.GREENBERG@Honeywell.comHCE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HR /HRC/CEO&nbsp;

_aandrade · Answer

Hi,&nbsp;Take a look at this video:&nbsp;https://www.youtube.com/watch?v=LyeAhV2665sProbably could help you.

anonymous · Answer

Thanks for the replay. In the link you shared he has Included and Exclude based on Country. But I have multiple columns as such.&nbsp;

Forum Discussion

Dynamic Row Level Security in Power BI with Exclude and Include rules

2 Replies

Related content

Dynamic Row level security

Dynamic Row level security issue

Dynamic Object-Level Security (OLS)

Dynamic Row Level Security

Implement Dynamic RLS with Azure Security Group

Emails	SBG	SBU	SBU excludes	SBE excludes	Region	Country	JoB Function exclude
[email protected]	PMT	HPS					HR /HRC/CEO
[email protected]	ALL						HR /HRC/CEO
[email protected]	ALL		ALT/HR&C	NTES/MSFS			HRC/CEO
[email protected]	HBT						HR /HRC/CEO
[email protected]	HCE					India	HR /HRC/CEO
[email protected]	HCE						HR /HRC/CEO