Row Level Security Reduce Data Problems

[Fievel25]

Hi Folks,

i've got a big problem with Row Level Security.

This is my application diagram:

"Access" Table is linked with "FactAmount" table thorught %PK_FACT.

"Fact Amount" Table is linked to "Projects" Table by IdProject.

I created a RLS on MailUserAccess field in "Access" Table and work fine in FactAmount table, i able to see only IdProject that a specific MailUserAccess can view (Left Field in below screenshot).

But table "Projects" shows always all IdProjects (Right Filed in below screenshot).

There's a way of seeing only id Projects that a user can view also in "Project" table?

Thanks

[v-robertq-msft · Accepted solution]

Hi, @Fievel25 

According to your description and the sample picture, the problem seems to exists in the relationship between ‘Project’ and the main table. Would you like to change the relationship between ‘Project’ and the main table to “Both” and check if it can work?

Thank you very much!

If this method can’t work, I think you should find a way to directly link the ‘Project’ with the RLS table, or try to create the RLS of MailUserAccess field in your main table.

Row-level security (RLS) guidance in Power BI Desktop

Dynamic Row Level Security in Power BI with Organizational Hierarchy

Best Regards,

Community Support Team _Robert Qin

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

[Gabriel_Walkman]

What kind of values does %PK_FACT stand for?