Forum Discussion
Dynamic role level security based on multiple rows of record
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!
Anonymous,
You may take a look at the following post.
1 Reply
v-chuncz-msftCommunity Support
Anonymous,
You may take a look at the following post.