© Reza Rad 2018
Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_17

17. Dynamic Row-Level Security

Reza Rad1 
(1)
Meadowbank, Auckland, New Zealand
 

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’ ...

Get Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.