In the June 2016 monthly Power BI release, Row Level Security (RLS) was introduced into Power BI desktop. This is great news for people using the application, especially as the configuration is stored within the Power BI model. Previously, you had to create the security in the web environment, which could easily be overwritten when publishing multiple times from a desktop workbook.
In this blog, I will show you how to set up RLS in Power BI desktop and how to test it works. My example uses the AdventureWorksDW2014 database (download here), specifically applying permissions for a manager. Each manager will only be able to see data for the Sales Representatives that report to them.
This is different from the SQL Server 2016 feature of the same name, but the concept is the same.