Forum Discussion

klehar's avatar
klehar
Helper V
4 years ago

Row Level Security with 2 columns

Hi,

 

I want to design row level security with 2 columns or 2 levels.

This is my security table

It has email, geo and segment.

 

There are 2 conditions here

1. a person have have geo and segment in any of the below combinations like 

APAC + HR or

All Geos + HR or 

APAC + All segments or

All Geos + All segments

 

2. a person can have multiple entries . eg. [email protected] 

can belong to 2 geos and 2 segments as well

Security Table
NameGeoSegment
[email protected]APACHR
[email protected]APACAll
[email protected]AllHR
[email protected]AllAll
[email protected]North AmericaHR
[email protected]APACMarketing
[email protected]LAHR
[email protected]LAMarketing

 

How can i design this RLS in Power BI modeling?

 

Also showing you other examples tables for reference

Geo Orders
GeoSales
APAC10
LA15
NA5

 

Segment Orders
SegmentSales
HR5
Marketing4
Finance21

 

1 Reply