Dynamic role level security based on multiple rows of record

[Anonymous]

Hi Community,

I'm new to the DRLS world and would like some help! I have a legacy security table and would like to apply it to power bi. There might be multiple rows of records that define the same user access. Example: 

Person	Region	State	Segment
A	West	*	*
A	Central	Wisconsin	*
B	East	*	*
C	Central	Wisconsin	*
D	South	*	Consumer
E	*	*	*

Person A would have access to all West region, and only access to Wisconsin in Central region. Person D should have access to all South region, but only in the Consumer segment,. Person E should have access to all the region, state, and segment. 

I tried different methods and still couldn't get it right. Any help would be really appreciated. Thanks!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Row-level-security-and-permission-to-view-All/m-p/287742#M126563