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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
RogerSteinberg
Post Patron
Post Patron

User Roles and Report Views not working

Hi ,

 

I've followed the correct method of apply filters and viewer roles for a report. 

 

1. I created the roles using a very simple filter in the PBI Desktop such as AccountId = 1 for the first role, AccountID = 2 for the second, AccountID= 3 for the third:

 

2. I've updated the RLS security by adding the company members ( using their email ) to their respective roles. 

2019-12-02 12_01_32-Power BI 22222.png

The test view works great but when asking those members to view the report, they don't have the same view. I.e, they see other accounts.

 

Any thoughts?

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @RogerSteinberg ,

I think the users are the members of your workspace. If users have access to edit content in the workspace, RLS can't restrict them. The document: Row-level security (RLS) with Power BI  has specific instructions:

Be aware that in the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

 

The relative role in workspace are admin, member and contributor. You could change their role to viewer. Then they will just view the data what you set.

 

Best Regards,

Xue Ding

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

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

I tried that. I put them as viewer and even removed them from the workspace and they were still able to view the full content.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.