RLS Relationship issues

[ankita_7]

Below are the points we are facing in powerbi report only when RLS is applied:

1.  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.
2. 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.
3. 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.

The visuals that are blank here are ment to be blank so that is not an issue only the visual showing cant show details is the one of our concerns.

Please let me know on the above if anyone detects the fault here.

Thanks in advance!

[Anonymous]

@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?

[Anonymous]

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

[amitchandak]

@ankita_7 , refer for RLS

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
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-bi

Avoid bi-directional join

[Pragati11]

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