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 everyone at the PowerBi Community, I have a very complex RLS situation. Whereby i have a fact table with these keys.
The user key is not in the Fact table Only the OrgUnitKey, AreaKey, JobCardTypeKey. For simplicity the userkey will be in my bridge usertable and in my bridgeOrgAreaCard table.
The problem I am facing is There are users that have access to only certain portions of data like in this instance user 317, has access to 3 Org Units and in this case should only see this data. The Area is tied to a specific OrgUnit and The JobCardType number can be tied to different OrgUnits. I can't choose one field to filter on here. because the User definately can't see all the data for the OrgUnits he has access to and the same way for the other 2 columns. So even if this User has Access to OrgUnit 2629 OrgUnit 2629 has many Areas and Many JobCards and he is to supposed to only see the access for that Areas and those job cards.
Hope this makes sense. Appreciate any help with this
Thanks
L
Hi @LucianH ,
You can refer to the following blog, which can help you create dynamic RLS rules with different paths:
http://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
There are also some related contents for your reference:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
85 | |
77 | |
66 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |