Dynamic Row-Level Security

Abstract

There are different methods to use row-level security in Power BI. You can set up Row-Level Security in Power BI itself, or through a live connection from a data source such as SSAS Tabular. However, row-level security defined in the way mentioned in the previous chapter above isn’t dynamic. By dynamic row-level security, I mean the definition of security is beside the user account information in the data source. For example, when John logs in to the system, based on data tables that show John is the sales manager for specific branch, he should be able to see only those branches’ data. This method is possible in Power BI using the DAX UserName() or UserPrincipalName() function. In this chapter, I’ll show you an example of dynamic row-level security with DAX USERNAME() function in Power BI.