Row level security implementation

[Hussein_charif]

Hi,

i have a power bi report with multiple pages that i want to apply RLS to.

the thing is the  report is created by someone before me and i cant really change much with the relationships, there are approximatly 156 tables.

the RLS i want to apply is for Sales Teams and Company Name. here are the involved tables that the report uses the sales team and company name slicers from :
Customers, Items, Salesteam.

the problem is with the pages in the report that use the Company Name and salesteam from the customer table.

i connected the Access tables to :
accessTeam <> Salesteam

accessCompany <> Items

mainly because almost all the pages use the company name and salesteam from those tables, except for 2 pages.

and i cannot establish a connection between the access tables and the customer table because i'd get a circular dependancy error, and i also tried creating seperate access tables for the customer table, but it doesnt work because the values of my measures would break and give wrong numbers.

how should i approach this problem to be able to solved with minimal to no change within the already created relations?

[Anonymous]

Hi @Hussein_charif ,

I don't recommend that you use Both- filter direction, which can lead to a circular dependency error, try to remove the existing bidirectional relationship, and use an intermediate table.

You can also use DAX functions to create calculated columns or measures to avoid establishing relationships directly between tables. For example, use the RELATED function to get data from a related table instead of establishing a relationship directly. RELATED function (DAX) - DAX | Microsoft Learn

Could you please provide a demo file that does not contain sensitive data, which can help us reproduce the problem and provide a more accurate solution?

Best regards,

Mengmeng Li

[Hussein_charif]

hi @Anonymous ,

the thing is that i really cant change much with the report's relationships since it was made a long time ago and there are way too many tables and pages and measures that could get messed up, which i have tried and encountered.

as for using calculated columns with for example related functon, i have also tried that but didnt help.

how can i share a copy file and replace all my sensitive data with other data btw?