OLS implementation
Let’s look at OLS implementation with a common scenario. The business wants to make the customers’ data visible only to the marketing team and the customers themselves. Therefore, no one who is not working in the marketing team must see the Customer table. The business also decided to secure all measures related to the OrderQuantity column from the Internet Sales table from the marketing team and the customers.
We will use the Chapter 11, OLS.pbix sample file provided with the book. The sample file is accessible here: https://github.com/PacktPublishing/Expert-Data-Modeling-with-Power-BI-Second-Edition/blob/main/Samples/Chapter%2011/Chapter%2011%2C%20OLS.pbix.
In the preceding scenario, we need to have two security groups available. One security group contains all the users except the marketing team members and the customers, and the other is for all the users. The following steps show how to implement the scenario:
- In Power BI Desktop...
