SQLBits 2024

Flight Plan for Data Security: Safeguarding your Dataset with Dynamic Object-Level Security

Unlock the secrets of dynamic Object-Level Security in Power BI Datasets using PowerShell. Learn to safeguard your data while you take off to new analytical heights.
In this session, you are going to discover how to use PowerShell to create roles with dynamic Object-Level Security (OLS) in your Power BI Dataset, ensuring your data remains locked down while your analytics soar.

To achieve secure and dynamic management of sensitive information in Power BI, we present an approach that combines PowerShell scripting over a Tabular Object Model with the creation of OLS through metadata configuration.

We are going to explore real-world scenarios with different degrees of complexity and showcase practical examples, taking your Power BI Dataset security to new heights.