This can be achieved in Power BI, by what is termed row-level security. Then, you manage who can see what data, from the row to the column level.


That way, with RLS in Power BI, data can be filtered down to the row level, with various roles defined in such a way that the users have access only to those data which is relevant to their role.

In Power BI service, only the people who have access to a workspace can see all the datasets. However, this is only for Viewer users as Admins, Members, Contributors will still be able to access all the data in the dataset.

For DirectQuery modes such as SQL Server, that cannot load data into the internal memory of the computer, RLS can only be defined at the dataset level.

To add RLS roles to the desktop, follow these steps:

1. Under the Modelling Tab, Select Manage Roles
2. Click on the New Role button.
3. Enter a role name.
4. Create a filter for the data users in the role can see.
5. Click on the OK button to save the role.

1. Under the Modelling Tab, Select Manage Roles
2. Click on the New Role button.
3. Enter a role name.
4. Create a filter for the data users in the role can see.
5. Click on the OK button to save the role.

In the Power BI service, you can use the Security option for datasets to assign roles to users.

Users will only be able to view the data that the role allows once they have been assigned a role.

Note: RLS is not supported for live connections to Analysis Services or Azure Analysis Services. For these types of datasets, RLS must be configured in the model.