Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hdemedici100
Frequent Visitor

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 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!

 

Screenshot 2024-11-13 142943.png

1 ACCEPTED SOLUTION
hdemedici100
Frequent Visitor

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!

Screenshot 2024-11-13 213458.png

View solution in original post

3 REPLIES 3
hdemedici100
Frequent Visitor

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!

Screenshot 2024-11-13 213458.png

Pragati11
Super User
Super User

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.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

 

Screenshot 2024-11-13 212349.png

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!