Power BI: Basic Row-Level Security

In this video, Angelica will explain what row-level security is and how you can easily implement it on your datasets to control users' access to the data. Row-level security (RLS) is a two-part process that begins in the Power BI Desktop and is completed in the Power BI Service. Row-level security allows you to restrict users' access to certain rows of data by creating a role that will filter down the data in the specified table you wish to apply security to.

00:00 - Introduction to Row-Level Security in Power BI
00:48 - Explanation of Row-Level Security Process
02:13 - Demonstration of Power BI Report without Row-Level Security
03:25 - Creating a Role to Restrict Data Access for a Specific Country
04:43 - Viewing the Report as a User Assigned to the Restricted Role
06:42 - Creating an "All Access" Role for Users Who Should Have Full Data Access
07:59 - Publishing the Report to the Power BI Service and Navigating to Security Settings
09:19 - Assigning Users to Specific Roles
10:36 - Testing Row-Level Security Roles to Preview User-Specific Data Access
11:00 - Closing Remarks

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -

Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #AngelicaDomenech

[ddd]

Extremely helpful. Precise and right to the point! Thanks.

[Oye_Shammi]

This was very well explained and quite helpful. Thank you.

[nadersheikh]

Great presentation and well explained. Thank You.

[ashutoshgadgil]

Thanks for explaining this in very simple manner

[ralfbecker]

Sehr gute kurze Erklärung. Vielen Dank!

[kbsikhn]

This video was extremely helpful and easy to follow along with. Thank you for sharing it.

[batreish]

Very helpful and well explained, great delivery, geat instructor

[sergiodiazdeleon]

Very helpful video. Will be following all videos.

[jackgoviz]

Excellent, greetings from Mexico, thank you.

[laurabackshell]

This is great - how do you apply Row-Level Security differently for different pages? Our summary page can be viewed by anyone but its the breakdown pages which we want to restrict.

[sairamreddy]

Thank you.
Can you make videos on KPIs.

[decemberflower]

Thanks for the video. may I check with you that, after added email address as role member. that user account need to have power bi license to view this report. how user will be viewing report? would you please help to clarify on that.

[wasifallvi]

Very Well explained!!! A baby could also understand it easily. Thank you very much.
Moreover, If I want to rename a 'role' and publish it, does that work?

[JenMayB]

Hi, I can’t get that in the Service - it says it is now handled in the Desktop? 😢 so confused.

[toddward]

I'm missing something. Performed all of the tasks and roles are testing correctly, but RLS is not being applied. Any user can see all data.

[vincentamsoms]

My power bi only shows the Dax option to filter.... How do I swap?
Or how do I put multiple filters with Dax?