Forum Discussion
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 | ||
| Name | Geo | Segment |
| [email protected] | APAC | HR |
| [email protected] | APAC | All |
| [email protected] | All | HR |
| [email protected] | All | All |
| [email protected] | North America | HR |
| [email protected] | APAC | Marketing |
| [email protected] | LA | HR |
| [email protected] | LA | Marketing |
How can i design this RLS in Power BI modeling?
Also showing you other examples tables for reference
| Geo Orders | |
| Geo | Sales |
| APAC | 10 |
| LA | 15 |
| NA | 5 |
| Segment Orders | |
| Segment | Sales |
| HR | 5 |
| Marketing | 4 |
| Finance | 21 |
1 Reply
- luohenResolver II
Hi klehar ,
What's your expected result? Could you please provide some specific examples to explain your requirement? Do you want to apply dynamic security? If yes, you can refer the following links to get it.
Define roles and rules in Power BI Desktop
You can enable dynamic security within Power BI Desktop by making use of the username() or userprincipalname() DAX functions and having the proper relationships configured.
How to Setup Static and Dynamic Row Level Security (RLS) in Power BI?
Best Regards