Forum Discussion

sivarajan21's avatar
sivarajan21
Post Prodigy
2 years ago

Avoid Bi-directional relationship in Dynamic Row level security using DAX

Hi,

 

I have below dynamic RLS(row level security) tables for my data:

The Dynamic RLS tables should filter the contacts table.

 

 
 
 
 
 
 

Intially,the bi-directional relationship between user allowed table and company management table causes performance issues.

So I removed it, and turned that into single directional.

 

Now I have filtering issues, so I tried to solve them using DAX in manage roles as below: 

 

 

But still its not filtering the company mangement table.

The filtering should travel from core user table to company management table to filter contacts table.

UnifyLive_UserAllowed_CompanyDetails table is just a bridge table created to avoid many-many relationship between core user and UnifyLive_UserAllowed_Company table

 

Can someone please guide, how to resolve this issue?

 

PFA sample raw file of these RLS tables and contact table here RLS.xlsx

Please let me know if you need further  info

 

Thanks in advance!

@Ahmedx @Greg_Deckler @amitchandak @Ashish_Mathur marcorusso  Ahmedx Greg_Deckler 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

    • sivarajan21's avatar
      sivarajan21
      Post Prodigy
      2 years ago

      Hi marcelsmaglhaes 

       

      Many thanks for your prompt response!

      Just to confirm, Snowflake model for only RLS tables?

      Could you please guide me on how to achieve this snowflake model for my data?

       

      Because of this RLS issue,we are not able to publish the report

       

      Let me know if you need further info!

       

      Thanks in advance

       

      • marcelsmaglhaes's avatar
        marcelsmaglhaes
        Super User
        2 years ago

        Yeah, you can create a snowflake model just for your RLS. Like something a hirearchy path between tables that have the information of security. In the image bellow we have a product path. The logic is the same to create the levels of informartion to the RLS. The last level have a one to many connection with the fact table and the RLS will be applied into the hole levels. But I'm afraid it will be necessary revise the entire data model to be effective. 

        Regards,
        Marcel