Using Row-level security with two different sources - Import and Direct Query

[hdemedici100]

I'm working on a dashboard which has two data sources - one is Import and one is Direct Query. They have a one-to-one relationship. I'm trying to use Row Level Security so viewers only see the details relevant to their capability. I've set up the roles, and the filters (I've only been able to apply the filter for the table which is imported). 

The end goal is to have the below table filtered. It is filtering some of the column data out as you can see below, but the first two columns (name and email) are still being shown - I was expecting the entire row to be hidden. How can I get it so the row level security filters the whole table and the viewers of the report only see the details which are assigned to their role? For reference, all the columns shown are from the Direct Query table, with capability being the only one in the Import table.

Thanks in advanced!

[hdemedici100 · Accepted solution]

I've actually just managed to figure this out myself, on 'Name' and 'Email' columns on the Visualisation settings, I had 'Show items with no data' ticked. I've unticked this now, and it's done just what I needed!

[Pragati11]

Hi @hdemedici100 ,

Can you please add details around what data model have you created to implement RLS?

A data model screenshot will be helpful to understand along with from which tables NAME and EMAIL are coming within the data model.

[hdemedici100]

Hi @Pragati11,.

Here you go. With the exception of the 'Capability' column which is in the Headcount table (import), all the other columns are from the Copilot user activity table (Direct Query). Some of them do have different names on the visual, I've just renamed them for that visual.