Power BI: Row Level Security
20 December 2018
Welcome to the last Power BI article of the year! This week, we’re going to look at Row Level Security, as a topic that has come up quite a bit in recent enquiries.
Row Level Security is exactly that – it’s a security setting that can be applied to individuals that restricts what data they have access to at the row level. Essentially, you can specify rules (e.g. Country = “Australia”) that filter the data that a user can see in their reports.
To set it up, go to the Modelling tab and find the Manage Roles button:
And from here, we can create a role that might be applied to our dataset:
By following the prompts, we can add a filter:
[EnglishCountryRegionName] = “Australia”
… that will restrict what “Australian Managers” can see to only those rows that match the filter criteria; that is, relate to the country in question.
Once we save and publish this data, we can go into the Power BI service to share our dataset to the Australian Managers. Under your workspace, go to Datasets, click on the ellipses and browse to Security:
This will then give you the ability to see who is restricted in this role, and to add members to specific roles.
That’s it for this year – nearly 50 blogs later and we’re still going strong! See you in 2019 with more Power BI tips and tricks!