Microsoft Power BI Cookbook

Dynamic columns and central permissions table

• Any dynamically computed columns, such as the Calendar Year Status and Calendar Month Status columns described in Chapter 6, Getting Serious with Date Intelligence, can make security roles more robust and resilient to changes.
• As more roles and role filter requirements are required of a data model, a central security role table can be built into a data warehouse with the names of distinct roles associated with the values of the columns to be secured. Queries against this table can be used by Import or DirectQuery data models to implement these roles via relationships. See the Building dynamic security into DirectQuery data models recipe later in this chapter for additional details.