RLS works on Desktop, but not on RS portal
Hi. I have defined two roles as follows: HierarchyPath: PATHCONTAINS(GIGPAYREQLISTPAGEVIEW[Path], MAXX(FILTER(DIRPERSONUSERENTITY, DIRPERSONUSERENTITY[USERID] = LEFT(UPPER(IF(FIND("\", USERNAME(), , 0) = 0, LEFT(USERNAME(), FIND("@", USERNAME(), , 0) - 1), MID(USERNAME(), FIND("\", USERNAME(), , 0) + 1, LEN(USERNAME()) - FIND("\", USERNAME(), ,0)))), 20)), DIRPERSONUSERENTITY[CurrentPosition])) HierarchyUser: [UserID] = LEFT(UPPER(IF(FIND("\", USERNAME(), , 0) = 0, LEFT(USERNAME(), FIND("@", USERNAME(), , 0) - 1), MID(USERNAME(), FIND("\", USERNAME(), , 0) + 1, LEN(USERNAME()) - FIND("\", USERNAME(), ,0)))), 20) Both roles filter a single table in my model to display part of data to the user via different paths (HierarchyPath filters target table GIGPAYREQLISTPAGEVIEW directly, HierarchyUser filters target table via another table and an active n:n relationship with cross-filter direction set to both). I need to assign both of these roles to each user so everyone can view everything related to them. The problem is that when I view report as a user with both roles on PBI Desktop RS, they work as expected. But when I publish it to RS portal, users can see ALL of the data! This means that RLS roles don't work. Desktop and RS versions are both Jan 2024. Thanks.
Organizational hierarchy RLS level 2 without path function
Hello I want to create RLS such as manager can see team members data (2 level below him ) in orgnizational hierarchy however in my case my there are some values in my "ManagerUID" column which are not present in "EMPUID" Column because of which I cannot use PATH() funtion For 1 level I have used following RLS dax [UID] = left(username(),6) || [LineManagerUID] = left(username(),6) || [Email] = username() || [LineManagerEmail] = username() Please help me to craete level 2 RLS Thank you in advanceRLS on Power BI Server
Hi, I'm new to RLS. To start, I believe RLS is used to restrict data view. Second, I'd like to know if I can type my employee ID and have the data displayed, including my EMP ID. Can I use RLS to fetch data from the backend because my datasets are vast in size? I want to load only the data that is connected to my entred EMP ID. Is this possible? Please assist I'm grateful in advance.
Can we use CONTAIN or CONTAIN STRING DAX in Row level security.
Hi I have attachted the screen shot below. I have Business group column there i have semicolon values like beauty wellbeing:personal care so when i use below it is saying format error. Is there any other way acheive this rquirement. So my goal is the when user login they can see beauty wellbeing, personal care vaues in drop down slicer. you can see error in below screen shot. I am using below DAX for Role [Business Group]= CONTAINS(AD, [Business Group], "Beauty & Wellbeing") || CONTAINS(AD, [Business Group], "Personal Care") Thanks in Advance
Row Level Security
Hello there. Currently I am trying to implement row level security on my data model. My company is not allowing the usage of Power BI service, which rules out any chances of me being able to use Cloud Services offered by Microsoft. Is there any other alternatives to be able to implement RLS into my model? I have heard about using dynamic row level security in SSAS Tabular Models, but the end result still is publishing the model to the Power BI cloud. I only have access to an SSAS Tabular Model and an onPremise PowerBI Report Server. Any guidance on this matter would be of great help to me. Thanks,
