- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RLS based on Category
Hello ,
I have employee data with different role , I want to restrict data based on Resource type
for example Employee (1) has resource type A and is location head can view only his data being a location head and related resource data fromsales table
can you please help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I do have a Refrence Table , with USERNAME we are mapping it to Resource Type
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Needs to be USERPRINCIPALNAME. their email address, basically.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@lbendlin Can't we do it with employee id USERNAME()......?,
and Could you please help me out on dax how can I restrict data based on Type for specific People
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For dynamic RLS you don't need anything else, but it must use USERPRINCIPALNAME, and your reference table must control the fact tables of the data model.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Okay and what would be my dax to filter the data as per specific category ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no DAX filter, this is all controlled via the data model.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I assume you have a reference table in your data model that maps USERPRINCIPALNAME to resource type?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-17-2025 11:17 AM | |||
06-30-2025 03:12 AM | |||
12-10-2024 03:26 AM | |||
03-20-2025 04:39 AM | |||
05-27-2025 02:45 PM |
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
1 |
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
3 |