Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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?
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.
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.