Power BI & DAX Row-Level Security
4.1 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled

Power BI & DAX Row-Level Security

Getting the most out of Power BI & DAX row-level security
4.1 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled
Created by Randy Minder
Last updated 4/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to set up row-level security for basic scenarios and more complex scenarios
  • How to set up row-level security for hierarchical data
  • How to create roles and DAX expressions to properly filter your data
  • How to deploy your row-level security to Power BI service and then assign users to your roles
  • How to test your roles, both in Power BI Desktop and Power BI service
  • Numerous practice questions and exercises to sharpen your skills
Requirements
  • A basic level of Power BI and creating simple DAX expressions will be useful
Description

If you are a DAX developer needing to secure your data so that your users only see the data they are supposed to see, row-level security is usually your only choice. This course will teach you about basic row-level security and dynamic row-level security, for more complex scenarios.

We'll also teach you how to set up security for hierarchical data, how to create roles and then test those roles in Power BI Desktop and Power BI service. We'll then demonstrate how to assign users to the roles you've created in the Power BI service. We will also demonstrate how to avoid bi-directional filtering when setting up your security.

After completing this course you should have a solid understanding of how row-level security can be used to secure your data in all sorts of scenarios.

Who this course is for:
  • Power BI developers needing to secure their data
Course content
Expand all 11 lectures 01:35:16
+ Introduction
3 lectures 11:11

An introduction to our course

Preview 05:47

In this lecture we discuss the main dataset used in this course

Preview 01:31

In this lecture we discuss the sample report which will be used to demonstrate how row-level security works

Preview 03:53
+ Basic row-level security
2 lectures 25:29

In this lecture, and the next, we explain and demonstrate how basic row-level security works

Part 1
13:59

We continue with basic row-level security

Part 2
11:30
+ Dynamic row-level security
3 lectures 30:56

This is part 1 of our discussion of dynamic row-level security

Part 1
10:30

We continue with our discussion on dynamic row-level security

Part 2
10:41

We continue with our discussion on dynamic row-level security

Part 3
09:45
+ Row-level security for hierarchical data
2 lectures 13:58

This is part 1 of our discussion of row-level security for hierarchical data

Part 1
08:05

We continue with our discussion of row-level security for hierarchical data

Part 2
05:53
+ Time for some practice
1 lecture 13:42

Some practice exercises to test your knowledge and skills

Practice exercises
13:42