Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |