Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PowerBI_Mallow
Frequent Visitor

Implementing Object Level Security in Power BI

 

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!

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @PowerBI_Mallow ,

 

maybe you can combine OLS and Field parameters as Chris Webb describes in this article: https://blog.crossjoin.co.uk/2022/05/22/stopping-some-users-seeing-certain-columns-or-measures-in-yo...

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @PowerBI_Mallow ,

 

maybe you can combine OLS and Field parameters as Chris Webb describes in this article: https://blog.crossjoin.co.uk/2022/05/22/stopping-some-users-seeing-certain-columns-or-measures-in-yo...

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi @TomMartens ,

Thanks for response, This approach works fine.

 

Regards,

PowerBI Mallow.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Carousel June 2024

Check out the June 2024 Power BI update to learn about new features.

2
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors