Microsoft Power BI Cookbook

Getting ready

1. Define and document the security role requirements to be implemented, and the members or groups of these roles.
2. Use the bus matrix diagrams described in Chapter 3, Building a Power BI Data Model to help communicate what data is currently stored in the model.
3. Validate that role security is indeed required (not report or model filters), given the risk or sensitivity of the data.

Do not confuse security role filters with the various other forms of filters in Power BI, such as report, page, and visual level filters, as well as filter logic in DAX measures. RLS role filters are applied to all queries of security role members, effectively producing a virtual subset of the data model for the given role at query time. Given the performance ...