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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Reza Rad
About this chapter
Cite this chapter
Rad, R. (2018). Dynamic Row-Level Security. In: Pro Power BI Architecture. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4015-1_17
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4015-1_17
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4014-4
Online ISBN: 978-1-4842-4015-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books