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 their own students, the school's principal to see all the teachers at their school, and the school board members to see all of the school's data. This level of granularity is quite possible in Power BI, but will require some thought ahead of time on how to lay out the data.
To show an example of this, we'll need to go back to the Power BI Desktop and open Chapter 5 - Visualizing Data.pbix
from a previous chapter's example; this file can be downloaded from this book's GitHub repository at https://github.com/PacktPublishing/Microsoft-Power-BI-Start-Guide-Second-Edition/blob/main/Completed%20Examples/Chapter%205%20-%20Visualizing%20Data.pbix. The goal of this example is to ensure that United States...