Learn your way! Get started

DA-100: Microsoft Power BI, Part 6 of 6: Row-Level Security

with expert Nikolai Schuler

Watch trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack

Release date 3/25/2021
Level Advanced
Runtime 1h 21m
Closed captioning Included
Transcript Included
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

This course discusses Row-Level Security Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. The DA-100 Exam validates this expertise.


Experience with Microsoft Excel, pivot tables and power pivot modelling is helpful.

Meet the expert

Nikolai is a mathematician and works as a data scientist in a large German company. He is focused mainly on gaining insights from data and creating a positive impact with this knowledge.

Course outline

Row-Level Security

Row-Level Security (24:09)
  • Introduction (00:13)
  • Row Level Security (03:20)
  • Creating RLS (04:51)
  • RLS in the Cloud (03:31)
  • RLS Data Model (04:38)
  • Dynamic RLS (07:28)
  • Summary (00:08)
Dynamic and Many-to-Many RLS (17:15)
  • Introduction (00:08)
  • Dynamic Many-to-Many (04:04)
  • Hierarchical RLS (04:03)
  • Implement Hierarchical RLS (03:07)
  • Manage Roles (05:44)
  • Summary (00:08)

Advanced M Language

M Basics (21:59)
  • Introduction (00:08)
  • DA-100 Update (01:06)
  • M Language Basics (06:40)
  • Values, Lists, and Tables (13:56)
  • Summary (00:08)
M Language Functions (18:31)
  • Introduction (00:08)
  • M Language Functions (13:13)
  • More Functions and Steps (05:02)
  • Summary (00:08)