User Access Issue

[mshass12]

Hello I have the following business requirement and I am trying to address it but I am still not able to fully get what I am looking for.

Scenario:

1- I have 15 companies and 5 regions. each company belongs to 1 region. I want to put a RLS so the user from individually company and view their own company data and its relevant region cumulative data. They should not be able to see the data of other companies in their own region and other regions.

2- One user may belong to more than 1 companies and more than 1 region.

3- I have created a user table with user id, user email, company and region.

4- I have also added the record where 1 user will belong to 2 companies operating in 2 regions.

5- I have a main table, one region table, one company table and one user table. 

6- I have made a relationship like user access> region>main and country>main.
7- so far I have create a dax which is atleast giving me information for 1 company and 1 region but if the user belongs to 2 companies and region then I am not able to see the second company and second region in my visualization.

Please help me get thru this.

[Ritaf1983]

Hi @mshass12 
Try this guide about Dynamic Row Level Security in Power BI with Many to many Best Practice:
https://www.youtube.com/watch?v=-MwysbrdVO0

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-aatheeque]

Hi @mshass12 ,

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[v-aatheeque]

Hi @mshass12 

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @mshass12 ,

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[danextian]

Hi @mshass12 

I am using this RLS DAX formula in one of my models.

USERPRINCIPALNAME () IN VALUES ( d_RLS[Email] )

The RLS table is connected to a dimension table in a many-to-many single direction relationship as the there can be more than one state for each user.