Forum Discussion
RLS Relationship issues
- The visual named labor details that has three tables info (kronos, KPITarget, adppaydata).Please check the screenshot named RLS issue. So when we make the relationship both ways between powerbi Rls table and company code table this issue is seen. Relationship screenshot is attached please check the attachment.
- If we make this relation one way then this issue is resolved but RLS doesn't work. We are using RLS to filter on facilities that are present in company code but after RLS it still shows all the facilities.
- Somehow we tried to make different changes in relationship to solve this issue but that affects the values in the visual and gives out wrong values/ unexpected.
4 Replies
Hi ankita_7 ,
Just wanted to check are you trying to implement Dynamic RLS?
If yes, in a way you should avoid bi-directional relationships and use DAX expression to implement RLS.
Check the following link which explains how we can avoid bi-directional relationship in RLS and implement it using DAX:
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
Thanks,
Pragati
ankita_7 , refer for RLS
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-biAvoid bi-directional join
HI ankita_7,
I think this should more be related to your relationships, they linked tables with so many fields and different types of filter directions.
You can take a look at following link about how AS tabular data model relationships mapping if it helps:
Relationships in analysis services tabular models
Regards,Xiaoxin Sheng
ankita_7 would you mind sharing how you connected your Kronos data? Was it using the REST API an if so how did you do this?
