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

Get Mastering Microsoft Power BI 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.