How to manage data access with DAX

[gabM]

Hi!

I need to manage access control over the data in my dashboard. There are multiple countries reporting data. One country in particular (SRO) has sensible data and therefore can only be accessible to members working there.

I've created a table where organization members' emails are associated with each of their respective countries.

Now, what DAX expression would allow me to specify that only members that login with an email associated to SRO should have access to SRO data?

 

I hope this makes sense,

Thanks!

 

[Pragati11]

Hi @gabM ,

You need Row Level Security in power BI to handle this scenario. Check the following blog:

https://radacad.com/row-level-security-configuration-in-power-bi-desktop

Thanks,

Pragati