Dynamic rls?

[lokosrio]

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	email	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?

[V-lianl-msft]

Dynamic RLS is not feasible. Logic does not support this, but you can try data masking.

Please refer to this blog:

https://radacad.com/secure-the-sensitive-data-in-power-bi-data-masking-better-with-row-level-securit...