Hi, In my data model, I have sensitive data like username, mobile number, etc., in the Users Table. My requirement is to show the User's details in the visual but with masked values only for a particular group of users(Report Consumers). While a certain group of users (lets say Admins) should be able to see the full data in the visual.
I have tried Object Level Security(OLS) on the columns with sensitive data for restricting the data. But this is not helping me out since OLS restricts on the dataset level and the visual breaks for the report consumers.
I want the visual to dynamically change the field values based on the logged in User(User or Admin). Like if a Report Consumer visits the report, it should show masked data and if an Admin visits the report, it should show full data without masking. Also I have a Search Box visual in my report to search for the users with Username and Mobile number fields which should work for the Admin to use it.
I have attached the sample .pbix file. The dataset provided is dump data. Here, I have applied OLS on Username, Mobile number and Email fields against Report Consumer role. Upon viewing the report as report consumer, the visual breaks. But I expect it to show a default value or encrypted one.
Thank you!
