Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI & DAX Row-Level Security
Rating: 4.4 out of 5(108 ratings)
409 students

Power BI & DAX Row-Level Security

Getting the most out of Power BI & DAX row-level security
Created byRandy Minder
Last updated 10/2020
English

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

Course content

5 sections11 lectures1h 34m total length
  • Introduction5:47

    An introduction to our course

  • The dataset1:31

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

  • Our sample report3:38

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

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