topic Re: Column masking based on user login in Developer

Column masking based on user login

ArunTiruveedula — Thu, 11 Feb 2021 21:18:15 GMT

Hello ,

I have a requirement from our user that they want to mask the contents of 'Person Name' in the Power BI grid/visualization/slicer based on the user login.

For example user1 (Power user) should be able see the contents of column 'Person Name' where as user2 (Normal user) should see the Masked data (replace name with technical key).

I can not create a measure for 'Person Name' because I need to use it slicer, bar graph axis etc.

My dataset is big enough, I can not consider duplicating each row in the FACT table and then apply RLS.

is there is any way out to this problem.

Thanks a lot in advance.

Re: Column masking based on user login

lbendlin — Fri, 12 Feb 2021 23:51:34 GMT

No. Your only (half) choice is the duplication you mention, but even that is not secure. Any reasonably advanced user can circumvent that.

If you have datasets that serve sufficiently different audiences then you need separate apps.

Vote for the Column Level Security idea.

Re: Column masking based on user login

Anonymous — Mon, 15 Feb 2021 06:33:23 GMT

Hi @ArunTiruveedula ,

To my knowledge, RLS (Row Level Security) could not be used to limit the columns or measures accessible by my users.

In other words,If a user has access to a particular row of data, they can see all the columns of data for that row.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Column masking based on user login

Anonymous — Tue, 23 Feb 2021 08:32:03 GMT

Hi @ArunTiruveedula ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin