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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
MattKarriker2
Helper II
Helper II

Object Level Security and Perspectives together

 

We are using Perspectives and visual personalization in our Power BI reports.  I now have a need to secure a table so only a subset of our users can access it.  I was looking to OLS for this.  I am sucessful in hiding the table from certain roles and allowing others to view the table.  So this is working also. 

The issue I have is with Perspectives used for report personalization.  Regarless of the role the user is in, the table and field names appear in the list for the user to select.  If a user who should not see the table tries to select one of the fields they receive an error that the table does not exist, as they should given OLS.  I am trying to figure out why the Perspective is showing the table as an option to the user.  I only have the option to hide or show the table in the Perspetive.  I need to show the table for the roles that need it and hide it for the roles that do and I need Persepctives to play along. 

 

Has anyone else run into a situation like this?  Any thoughts on how this might be accomplished?

1 REPLY 1
parry2k
Super User
Super User

@MattKarriker2 great point, I didn't use OLS with Perspective and I expected it to hide the tables in the Perspective, and based on your post seems like it doesn't do that which is weird. If and when I get some time I will probably test it. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.