Forum Discussion
Solved
Adding a restriction to RLS
I have a PBI desktop report I publish to service that uses RLS. The current configuration has a table "RLS" that refreshes an excel file with the columns "Username:, Division", and "Email". The ...
Hi! Row Level Security (RLS) only restricts rows. If you would like to restrict columns and such you will need Object Level Security (OLS) which can be achieved using Tabular Editor 2. Here is a link to explain in much greater detail: Object-level security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn
z-rising Be aware that RLS uses a least restrictive model when it comes to users who fall into multiple roles. Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
That's interesting. It's been working correctly for me so far in the user access, I haven't had any feedback that anyone can see (or not see) other divisions.
