Object-Level Security in Power BI
In this Power BI tutorial, you’ll learn how to lock down your data model using Object-Level Security (OLS). Not to be confused with Row-Level Security, OLS doesn’t simply hide rows of data from the end user. OLS instead hides whole tables or columns!
In the video, we decide to hide an entire column pertaining to sales revenue. From then on, the end user will not be able to see this column in their report, nor will they be able to see any measures that rely on the column! It’s important to note that this security applies when the user views the report, when the user analyzes the model with Analyze in Excel, and when the user connects to the dataset within Power BI Desktop. It completely hides the restricted columns/tables/measures, almost as if the items don’t exist at all!
--------------------------------------------------------------------------------------------------
To enroll in my introductory or advanced Power BI courses:
https://training.bielite.com/
Blog Post/PBIX Download:
https://bielite.com/blog/object-level...
Elite Power BI Consulting:
https://bielite.com/
Data Insights Tools:
https://www.impktful.com/
Tabular Editor:
https://github.com/otykier/TabularEdi...
Connect with me on Twitter!
/ powerbielite
0:00 Intro
0:55 Setting up OLS
6:46 Viewing as User
9:39 Outro
Watch video Object-Level Security in Power BI online without registration, duration hours minute second in high quality. This video was added by user BI Elite 02 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 34,954 once and liked it 796 people.