Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi,
I have a question regarding data restriction. Dashboard is way more complicated than my example, but I want to make it easy to understand.
I have a table with permissions like this:
user_id | team | |
1 | abc@x.com | team1 |
2 | def@x.com | team1 |
3 | ghi@x.com | team2 |
and fact table:
user_id | region | sales |
1 | us | 10 |
2 | de | 20 |
3 | us | 30 |
I have 3 charts on the visualization - one represents sales per users, second sales per regions and third total sales.
When user open the report then he see this data (for example user_id 1):
- first chart: only his data (sum = 10)
- second chart: data belongs to his region (sum = 30)
- third chart: total (sum = 60)
I am wondering if this can be achieved by dynamic rls, filters on page or maybe something else?
Dynamic RLS is not feasible. Logic does not support this, but you can try data masking.
Please refer to this blog:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |