SQLBits 2024
Advanced data security implementation for Power BI
We explore all the aspects you need to know to fully implement data security in Power BI, based on previous implementations. Yes, RLS is one of them, but we need to look at object-level security (OLS), audiences, active directory (Microsoft Entra), and a well-defined data model to support this.
Are you facing data security issues? Then, there is a good chance that row-level security (RLS) alone will not get you there. The question is more complex than the possibilities that RLS offers.
What if a manager is only allowed to see the average absenteeism of another department but at the personal level of his department? And another colleague is allowed to see the names but not the email address or other sensitive data? And if this differs between domains (employee, client, finance)?
We explore all the aspects you need to know to fully implement data security in Power BI, based on previous implementations. Yes, RLS is one of them, but we need to look at object-level security (OLS), audiences, active directory (Microsoft Entra), and a well-defined data model to support this.
I know, you have to see it work first! So this session has a lot of demos.
Key takeaways:
- Understand and define different data security scenarios
- When and how to configure RLS, OLS, audiences, active directory, and the data model according to your scenario
- How to deal with advanced data security scenarios
- Additional data security for building end-user reports
What if a manager is only allowed to see the average absenteeism of another department but at the personal level of his department? And another colleague is allowed to see the names but not the email address or other sensitive data? And if this differs between domains (employee, client, finance)?
We explore all the aspects you need to know to fully implement data security in Power BI, based on previous implementations. Yes, RLS is one of them, but we need to look at object-level security (OLS), audiences, active directory (Microsoft Entra), and a well-defined data model to support this.
I know, you have to see it work first! So this session has a lot of demos.
Key takeaways:
- Understand and define different data security scenarios
- When and how to configure RLS, OLS, audiences, active directory, and the data model according to your scenario
- How to deal with advanced data security scenarios
- Additional data security for building end-user reports