How to manage data access with DAX

gabM — Fri, 05 Feb 2021 16:22:37 GMT

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!

Re: How to manage data access with DAX

Pragati11 — Fri, 05 Feb 2021 16:26:16 GMT

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

topic How to manage data access with DAX in DAX Commands and Tips

How to manage data access with DAX

Re: How to manage data access with DAX