Forum Discussion
Solved
Using Row-level security with two different sources - Import and Direct Query
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 detail...
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!
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.
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.