Dynamic Row Level Security in Power BI

There are different methods to use row-level security in Power BI; You can set up Row Level Security in Power BI itself or through a live connection from a data source such as SSAS Tabular. However, row-level security defined in the ways mentioned in the articles above isn’t dynamic. By dynamic row-level security, I mean the definition of security is beside the user account information in the data source. For example, when John logs in to the system, based on data tables that show John is the sales manager for a specific branch, he should be able to see only those branches’ data. This method is possible in Power BI using DAX UserName() or UserPrincipalName() function. In this video, I’ll show you an example of dynamic row-level security with Power BI’s DAX USERPRINCIPALNAME() function.

[@Bvcggdert]

You seriously are awesome and Microsoft learning in Coursera directly references your material. Bravo!

[@1yyymmmddd]

Didn't quite get why one should add "People or Groups who belong to this role" if you control access by username?

[@NutanPatel]

we need to manually add the user under the members list of dataset. do we really require because we implemented dynamic RLS?

[@Milhouse77BS]

Glad to see this update. Trying to use dynamic RLS here at my work.

[@RADACAD]

Thanks Donald

[@CU3RV008]

Thanks for putting this together, I just started working with PowerBi and this video helped me solve a big challenge.

[@DuncanFairweather]

You say if I am new to RLS, I should check out your earlier video about static rls but a search does not turn up any such video. Could you please supply a link?

[@HARSHALK-s6m]

Hi Reza, Can you please tell me how to implement RLS on embed power bi report on company portal or sharepoint?

[@Najla-us6pz]

+1

[@hossein3945]

That's solid Gold. Thank you Reza for sharing this.

[@RADACAD]

Thanks Hossein jan!

[@adityaprakash9151]

Hello sir, in a scenario I have a table of user with email id and country I want to apply row level security on my report that means user can reports of their belonging countries , but there is a problem I m facing where the data is present in that table country column is storing countries in conacanated form means India,Uk,Australia such please suggest

[@kaustubhbandewar9815]

Hi Sir, I have one question, I have similar use case however, i have a table with many to many relationship. can RLS work in many to many set up ? here you are forming one to many relationship which is working for me. I have tried to create a bridge table with just the common column. but still it does not work

[@RADACAD]

I will have a video about that coming soon :)

[@scooby990]

Hi , how can I use dynamic RLS for some data and others. By location and region

[@jasoncalvert4065]

Thank you mate, good easy to understand example of dynamic RLS

[@donnacarter1602]

This helped me so much, thank you for sharing!

[@RADACAD]

You're so welcome!

[@lachuynh85]

Thanks so much, your guidance is very clear and useful.

[@RADACAD]

Glad it was helpful!

[@abdulfiroz9]

Hi Raza, can you explain Dynamic RLS to be applied to change theme of power bi report as per user login?

[@gokulsthev]

Hi Reza, is it possible to build RLS when using live connection to power bi dataset, by importing a new excel sheet with roles and connecting to the live connection's model?

[@pthapa55]

Thanks for such a good post however I still have one question. Is the row level done in Power BI desktop or is it done after the report is published in the workspace? Or do we need to do it at both places? I am confused. Thanks

[@RADACAD]

You just do it once in the dataset, and all the reports connected to it will follow that rule.

[@pthapa55]

@@RADACAD Thanks

[@thejishubasak]

Hello Reza. Thanks for simplifying RLS. I have one question. How do I make sure that when I am accessing the published report, I can atleast the the details personalized to me(like for example, welcome message and my profile picture)? It work fine if other users are accessing it, but when I access it, I see the image and name of the first user in the Employee Database

[@laurarodas1511]

Hello Reza, thanks for your videos, you explain very well but I have a question, does Power Bi have double authentication for integrated dashboards? Can I double authenticate when I login? I need to implement more security levels for my clients and I don't know how to do it, thank you.

[@RADACAD]

Thanks :) If by double authenticate you mean multi-factor authentication, where you use mobile or a second mean to authenticate when you login, then yes. You can enable multi-factor authentication for the users in the Office 365 admin center.

[@noahhadro8213]

In the Power Bi Service does the RLS security get applied once meaning the queries are applied only once to reduce the model at the beginning of the session OR do the queries get run every time a visual loads or you go to a new page?

[@erinfield1943]

3:38- static row level security 5:57- dynamic row level security

[@anmfaisal964]

Hiw to use row level security for external email holders

[@jrazafindrabe5229]

Hello, Why is it necessary to add email or email group in the published report. Isn`t it automatically recognized by the person who log-in.

[@jackhillyer3397]

to identify which records in the fact table get included by matching the keys from the chosen user in the security table

[@ellanguyen5335]

Thank you for sharing this video. The guide is really details and I got it working! Thanks Reza

[@RADACAD]

Glad it helped!

[@joserocha9400]

Hello Mr Reza, thank you for sharing this. I have an issue, if there is an user that have to has total access to the report besides the others users not, what to do? Thanks in advance!

[@RADACAD]

Hi. Jose I have explained it in my article here: radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

[@muhammetmuslu4429]

Thank you for this good video

[@Soulenergy31]

Thank you Guru! 8:24 - 11:00 share the RLS report with others

[@ranjanroy1623]

Hi Reza, thanks for this video , it is amazing always . Do you have any video/ series/ blog on Power Bi embedding as well , if you can pls share the link

[@RADACAD]

Not yet, hopefully in the future

[@praveenkumar_0143]

Well- Explained 👏👏

[@RADACAD]

Thank you 🙂

[@EhsanRavana]

درود آقا رضا🎉

[@Charlie888]

[@bkd-newyork2256]

nice

[@aamirbaig5236]

Hi Reza. I just checked and confirmed that office 365 group (Everyone) does not support in Row level Security I saw this on guy in the cube kzbin.info/www/bejne/pam8gmV9fMqZqNU (exact time 3:22 ) Please confirm your understanding. Thanks a lot Very informative video on RSL.

[@Lotaristo]

It's not supported (read in official documentation)