Microsoft Fabric offers a wide range of options to define permissions for both item and data access, using different scopes of the platform. As options keep evolving, it's a challenge to determine a viable permission strategy that works for the use cases at hand, offers business users the flexibility they are looking for, and passes those dreaded security checks to be able to move to production.

Focusing on a typical lakehouse architecture for data analysis using Microsoft Fabric, we'll explore the different options that exist to provide access to items and define data security rules. We'll discuss how these different options can impact business users, walking through pros and cons, and providing examples that are manageable and usable at scale. Above all, the guiding principle of least privileged access is our north star, making sure we do our part to keep company data safe.

We'll tie personas and use cases to common data access patterns and assess how Microsoft Fabric can help us get the data closer to where the business user is, helping them to make better informed decisions using validated data.

After wrapping up the walkthrough, people should feel informed about the different options that exist, empowered to make their own decisions based on their own use cases and requirements, and reassured that it really isn't that complicated as it seems.