User Profile
gsk135
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Override RLS
I have a table which has a region field. I created a table as access with username, region, useradmin. I want to filter region on main table based on the username and region from access table. Useradmin's should able to see all the regions and should not filter anything. I tried below roles but it did not work. [username] = USERPRINCIPALNAME() if ( [username] = USERPRINCIPALNAME(), true(), [useradmin]=USERPRINCIPALNAME())Solved534Views0likes1CommentRLS with Page level security
I created a main page and two pages in the same report. Page A and Page B main summary table contains all the data including fields region I created a file PLS.txt with columns username report region [email protected] page A CA [email protected] page A DC [email protected] page B WA [email protected] page B IL On row level security I created a new PLS role and put as [username] = USERPRINCIPALNAME() This worked and assigned usernames only able to view either Page A or Page B from main page. Now I want to restrict usernames to only view the region that they are assigned. How should I do it?Solved800Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.