Row level security Help

[vpawan]

Hi,

Can any one please help me to apply row level security on country and also need to filter departments related to country.

I have the data model like below. Between Department and country i have inactive relationship. please help me how to achive RLS on country with relavent Departments filter.

User emails are coming from User table which is also have realtionship with fact table

Thanks in advance

[Anonymous]

Hi @vpawan ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

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

[RossEdwards · Accepted solution]

The first consideration is going to be your model.  Right now you are filtering Invoice based on Country and Department separately.  This being that your invoice record must have some ID that links to Country and another ID that links to Department.

When you turn on the inactive relationship, Power BI will ignore the direct link of Country & Invoice and apply all country filtering via Department.

From a row level security perspective, which direction do you want Row Level security to filter via?  Do you want Country to filter invoice directly, or department?  I cannot be both.

Once you have made that choice, modify your relationships to match your choice above, then row level security should work.