cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gabM
New Member

How to manage data access with DAX

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.Screenshot 2021-02-05 164855.png

 

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?

 

Screenshot 2021-02-05 163810.png

I hope this makes sense,

Thanks!

 

1 REPLY 1
Pragati11
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors