Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lokosrio
Helper II
Helper II

Dynamic rls?

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_idemailteam
1abc@x.comteam1
2def@x.comteam1
3ghi@x.comteam2

and fact table:

user_idregionsales
1us10
2de20
3us30

 

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?

1 REPLY 1
V-lianl-msft
Community Support
Community Support

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... 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.