Setting up row-level security
In most organizations, security is not just a report-level decision. Organizations want more granular decisions, such as whether a sales executive can only see his or her own data. Another example is the ability for a teacher to see his or her own students, but the school's principal can see all the teachers at their school and the school board members can see all of the data. This level of granularity is quite possible in Power BI, but will require some thought ahead of time on how to lay the data out.
To show an example of this, we'll need to go back to the Power BI Desktop and open Chapter 5 - Visualizing Data Completed.pbix from a previous chapter's example; this file can be downloaded from this book's web page at http://packtpub.com. The goal of this example is to ensure that United States sales managers can only see US sales, and likewise for Australian sales managers. We'll only use two countries in our example, but the same example can apply to the...
