Advanced data security implementation for Power BI

Session description

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

Hylke Peek

BI and Data Analytics Consultant, Peek Data Consultancy

Hylke is a BI and Data Analytics consultant. He delivers data and BI solutions for various organizations for more than 10 years. His focus is SQL Server, Azure, Power Platform and Python. But he founds everything interesting, as long as it involves data.

Hylke also provides training on these topics and speaks regularly on national and international events. The biggest fun of all this? Gaining new knowledge!