Introduction to OneLake Security in Fabric (Row, Column & Object Level Security)

Locking down data in Microsoft Fabric has never been more central—or more confusing—until now. In this video, Manuel Quintana from Pragmatic Works walks through OneLake Security (currently in preview), showing how to centralize row-level, column-level, and object-level security directly in your Fabric lakehouse. You’ll see how to turn on OneLake Security, work with the new Manage OneLake Security pane, and build roles that control exactly which tables, rows, and columns users can see. Manuel builds a “no customer” role, limits access to only certain territories, and demos how those rules flow through to semantic models, reports, and ad-hoc analysis—all without hacking around with T-SQL or scattered RLS in individual models. By the end, you’ll understand how OneLake Security becomes the single security wall for your lakehouse: applied once at the data layer and respected everywhere it’s used in Fabric. Whether you’re planning a new Fabric rollout or cleaning up an existing environment, this is a must-see overview of the new security model. 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ 00:00 – Intro & why OneLake Security matters 00:48 – What is OneLake Security in a Fabric lakehouse? 01:50 – Enabling OneLake Security & the default role 03:15 – Building a “no customer” role (object-level security) 06:09 – Adding row & column level security rules in the UI 08:21 – Testing the role in reports (what the user actually sees) 09:35 – How security flows to semantic models & other tools Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook: https://prag.works/yt-fb ✔️Instagram: https://prag.works/yt-insta ✔️LinkedIn: https://prag.works/yt-li Pragmatic Works 350 Governor St, Suite 300, Green Cove Springs, FL 32043 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks