Common RLS implementation approaches

There are usually two different approaches to implementing RLS in Power BI Desktop: static RLS and dynamic RLS. In the following few sections, we look at both approaches by implementing real-world scenarios.

Implementing static RLS

A static RLS approach is used when we define rules that statically apply filters to the data model—for example, in Figure 11.2, we created a static RLS rule to filter the Internet Sales amounts by currency when the currency equals AUD. Static RLS is simple to implement, but it can get quite expensive to maintain and support. However, in some cases, static RLS is just enough to satisfy the business requirements—for instance, when the data model does not include data to support dynamic RLS, implementing and supporting dynamic RLS can be more expensive than implementing and supporting static RLS. A good example is in an international organization with a few security groups within Azure Active Directory...