Security Tables
Based on the data security needs for this project described in Chapter 1, Planning Power BI Projects, it's not necessary to retrieve any tables for the purpose of implementing a row-level security (RLS) role. As shown in the Sample Power BI project template section in Chapter 1, Planning Power BI Projects, the sales managers and associates should only have access to their Sales Territory groups, while the Vice Presidents should have global access. With these simple requirements, the security groups of users (for example, North America, Europe, the Pacific region) can be created and assigned to corresponding RLS roles defined in the data model. See Chapter 4, Developing DAX Measures and Security Roles, for details on implementing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access