Secure the Sensitive Data in Power BI Data Masking better with Row Level Security

In my previous article/video, I explained how you can hide sensitive data from the user's view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to create DAX measures, then there is a better and more secure way. In this video, I am explaining that method.
Download the Power BI file and learn more from my blog article here:
radacad.com/secure-the-sensit...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********

[@Babayagaom]

This channel deserves more subs

[@mohammedadnan2147]

Great insight...

[@totvabe1]

In 8:25 you talk about creating the no bidirectional relationship, but single. OK, but the with the CROSSFILTER() function the user can modify this relationship and Access to the hidden indormation, can't he?

[@RADACAD]

Good question. Even in that alternative approach I mentioned, the "Current User Table" still needs to be filtered using RLS. which means even if the user changes it using CrossFilter function in DAX, still it won't reveal any information that the user shouldn't see, because the table is already filtered.

How about hide an entire column to some users? Is that possible?

[@RADACAD]

column level security is not YET available in Power BI. However, considering that now we have XMLA write capability, that is not far away I guess.

[@yes-pg5dy]

@@RADACAD Hi Sir, can we achieve column level security using Data Masking ?