Forum Discussion
Solved
Dynamic Row Level Security
Hello, I am relatively new to PBI and working on implementing dynamic row level security. The goal is for the user to be able to see values for a specific field they have access to and blank values ...
This is what my department has been tasked with to mirror PBI to what other data individuals see in our other systems. Filtering down to just show what they have full access to is in the RLS table was what I started with, but now we need to make sure they can see all employees (not just the filtered down people) but only have access to their permissioned data for sensitve data fields with other values just simply being blank.
The non-sensitive table currently is only joined to the sensitive table in a single direction relationship (NS filters the S table), if that helps.
They should not be joined at all. Think of them as separate fact tables.