What you will learn

  • Restrict data

    Learn how to restrict data for different users within Power BI Desktop for your datasets.

  • Dynamic Security

    Understand how to dynamically restrict data to avoid creating numerous roles that are hard to manage and maintain.

  • Deploy and manage

    Learn how to deploy and then manage your dataset and row-level security configuration once deployed to the Power BI service.

Social proof: reviews

Gregg Froelich

5 star rating

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

→Read Less

Klaus Trampedach

5 star rating

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

→Read Less

Md. Shafiuzzaman Rajib

5 star rating

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

→Read Less

Alok Tandon

5 star rating

“very helpful. now I have to think about the best way to implement this in my organization”

“very helpful. now I have to think about the best way to implement this in my organization”

→Read Less

Charlie Holland

5 star rating

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

→Read Less

Zak Lewis

3 star rating

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

→Read Less

Gregg Froelich

5 star rating

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

→Read Less

Klaus Trampedach

5 star rating

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

→Read Less

Md. Shafiuzzaman Rajib

5 star rating

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

→Read Less

Alok Tandon

5 star rating

“very helpful. now I have to think about the best way to implement this in my organization”

“very helpful. now I have to think about the best way to implement this in my organization”

→Read Less

Charlie Holland

5 star rating

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

→Read Less

Zak Lewis

3 star rating

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

→Read Less

Gregg Froelich

5 star rating

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

“Very informative and entertaining lesson. It's what I was hoping to get out it. ”

→Read Less

Klaus Trampedach

5 star rating

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

“These guys explain the stuff so its understandable. And then there's also a lot of fun going on during the course... :) Worth every $!”

→Read Less

Md. Shafiuzzaman Rajib

5 star rating

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

“IMHO this course is probably the most enjoyable way to learn RLS. Clear concepts with examples. Thanks a lot to Adam & Patrick for making such great learning resources!!! ”

→Read Less

Alok Tandon

5 star rating

“very helpful. now I have to think about the best way to implement this in my organization”

“very helpful. now I have to think about the best way to implement this in my organization”

→Read Less

Charlie Holland

5 star rating

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

“The class provided the exact information I was looking for to implement RLS in the company I'm working for. ”

→Read Less

Zak Lewis

3 star rating

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

“I pretty much knew the majority of the RLS. I still haven't been unable to complete my project, I wish there were more examples around real-life data as you know it's never straight forward.”

→Read Less

Course curriculum

    1. Welcome to Row-Level Security

      FREE PREVIEW

    2. How to use this course

    3. Course Files

    4. What and Why of Row-Level Security

      FREE PREVIEW

    1. Static RLS with a Single Role

    2. Validate your RLS

    3. Static RLS with Multiple Roles

    4. Dynamic RLS with a Single Role

    5. Dynamic RLS with Many to Many

    1. Configure RLS in the Service

    2. Using RLS with Apps

    1. Configure RLS for Managers / All Rows

    2. RLS Performance

    3. What's next

    1. Congrats! You made it!

    2. Behind the scenes

    3. More resources for you

About this course

  • $89.00
  • 17 lessons
  • 2 hours of video content

Instructor(s)

Instructor Bio:

Adam Saxton & Patrick LeBlanc have extensive knowledge about Power BI and have been working with the Microsoft Business Intelligence stack since 2004. They have both spoken at international conferences and are active in the Power BI and SQL Server communities. Guy in a Cube has been publishing videos on YouTube since 2014.

Adam Saxton Patrick LeBlanc Marthe Moengen

Instructors

Pricing options

Begin your Row-level security journey now!

Get started now

Buy Now