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-security-power-bi/
Elite Power BI Consulting:
https://bielite.com/
Data Insights Tools:
https://www.impktful.com/
Tabular Editor:
https://github.com/otykier/TabularEditor/releases/tag/2.14.2
Connect with me on Twitter!
https://twitter.com/PowerBIElite
0:00 Intro
0:55 Setting up OLS
6:46 Viewing as User
9:39 Outro
Видео Object-Level Security in Power BI канала BI Elite
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-security-power-bi/
Elite Power BI Consulting:
https://bielite.com/
Data Insights Tools:
https://www.impktful.com/
Tabular Editor:
https://github.com/otykier/TabularEditor/releases/tag/2.14.2
Connect with me on Twitter!
https://twitter.com/PowerBIElite
0:00 Intro
0:55 Setting up OLS
6:46 Viewing as User
9:39 Outro
Видео Object-Level Security in Power BI канала BI Elite
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![What is Object-Level Security (OLS) in Power BI? | RLS Vs OLS in Power BI | Power BI](https://i.ytimg.com/vi/0Tj_TqbzFMM/default.jpg)
![How to use Microsoft Power BI - Tutorial for Beginners](https://i.ytimg.com/vi/TmhQCQr_DCA/default.jpg)
![Exploring Object Level Security in Power BI - Unplugged #13](https://i.ytimg.com/vi/8s3MByrZJgg/default.jpg)
![Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop](https://i.ytimg.com/vi/-kaUnBXvvGo/default.jpg)
![Simple Moving Average (SMA) in Power BI](https://i.ytimg.com/vi/nvv4tPOY8lo/default.jpg)
![Intro to R with Power BI](https://i.ytimg.com/vi/NomSliJK3s4/default.jpg)
![Security in Power BI - Quick Overview](https://i.ytimg.com/vi/htNPWWvJs4Q/default.jpg)
![Create Buckets or Groups with Power Query in Power BI](https://i.ytimg.com/vi/D1LO8syugMA/default.jpg)
![New Sharing Experience for Power BI Reports](https://i.ytimg.com/vi/Vr-ON9wULfE/default.jpg)
![Power BI - Dynamic Categories in the Small Multiples Visual!](https://i.ytimg.com/vi/fktQmk0a9OI/default.jpg)
![Static and Dynamic Row Level Security in Power BI](https://i.ytimg.com/vi/lc9oawAWorM/default.jpg)
![Handling MULTIPLE fact tables in Power BI](https://i.ytimg.com/vi/TnyRsO4NJPc/default.jpg)
![Data cleaning in Excel - 10 tricks *PROs* use all the time](https://i.ytimg.com/vi/SNVjndgWBlw/default.jpg)
![Amazing Power BI Reports for Inspiration - April 2021 Contest Winners](https://i.ytimg.com/vi/l6NspVReKz0/default.jpg)
![How to use DYNAMIC ROW-LEVEL-SECURITY (RLS) in Power BI // Beginners Guide to Power BI in 2021](https://i.ytimg.com/vi/axTyP7I2Bso/default.jpg)
![REAL TIME Reports in Power BI! (Including Power BI Free & Pro)](https://i.ytimg.com/vi/iyGBZsLxe54/default.jpg)
![Setting Up Power BI Row Level Security](https://i.ytimg.com/vi/Sv0bZ6jDmI4/default.jpg)
![What is Query Diagnostics for Power BI? | Query Diagnostics | DA-100 Tutorials | BI Consulting Pro](https://i.ytimg.com/vi/J3IUgnaex04/default.jpg)
![Exploring the Power Automate Visual in Power BI | Sending emails](https://i.ytimg.com/vi/T0dsCUeCFjg/default.jpg)
![Combining Object Level and Row Level Security in Power BI and Azure Analysis Services](https://i.ytimg.com/vi/a0Oi3kz8ibk/default.jpg)