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.
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.
Speakers
José Calheiros's previous sessions
Power BI: Optimizing Your Analytics Journey
Embark on a data-driven adventure to explore Power BI's architecture, data modeling, reporting, and deployment in an enterprise BI scenario. This training day will cover best practices, optimization, and performance techniques. (in-person only)
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.
Diogo Martins
Diogo Martins's other proposed sessions for 2026
Reach for the Sky! To Automated Report Delivery and Beyond - 2026