Advanced data security implementation for Power BI
2024TL; DR
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.
Session Details
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
3 things you'll get out of this session
Speakers
Hylke Peek's previous sessions
Govern your data in Fabric
If you want to get started with Fabric and are curious about how you, as an organization, can keep control over your data, then this session is for you.
In this demo-rich session, we'll look at how to manage your data in Fabric. The session is intended for anyone involved in managing a Fabric environment.
Merging Power BI into Azure Devops
From a development perspective Power BI gives you some challenges you can't overcome easily. When you and your team are continuously working on Power BI files, you need a central location, to keep track of changes, find differences between versions, check out files and deploy in an easy way.
In this sessions we will see how Azure DevOps helps you with versioning, CI/CD-pipelines and tracking changes in datamodels.