Dynamic Row Level Security in Power BI

Рет қаралды 64,243

Жыл бұрын

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.

Пікірлер: 39

@KnewnAnt 4 ай бұрын

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

@CU3RV008 4 ай бұрын

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

@jasoncalvert4065 6 ай бұрын

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

@Milhouse77BS Жыл бұрын

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

@RADACAD Жыл бұрын

Thanks Donald

@hossein3945 Жыл бұрын

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

@RADACAD Жыл бұрын

Thanks Hossein jan!

@ellanguyen5335 Жыл бұрын

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

@RADACAD Жыл бұрын

Glad it helped!

@muhammetmuslu4429 Жыл бұрын

Thank you for this good video

@thejishubasak 10 ай бұрын

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

@noahhadro8213 8 ай бұрын

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?

@gokulsthev 8 ай бұрын

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?

@Soulenergy31 8 ай бұрын

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

@praveenkumar_0143 10 ай бұрын

Well- Explained 👏👏

@RADACAD 10 ай бұрын

Thank you 🙂

@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

@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

@abdulfiroz9 5 ай бұрын

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

@DuncanFairweather 20 күн бұрын

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?

@user-fj7im5dz1j Жыл бұрын

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

@Najla-us6pz 10 ай бұрын

@ranjanroy1623 11 ай бұрын

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 10 ай бұрын

Not yet, hopefully in the future

@jrazafindrabe5229 5 ай бұрын

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.

@laurarodas1511 10 ай бұрын

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 9 ай бұрын

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.

@scooby990 2 ай бұрын

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

@adityaprakash9151 4 ай бұрын

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

@EhsanRavana 7 ай бұрын

درود آقا رضا🎉

@anmfaisal964 7 ай бұрын

Hiw to use row level security for external email holders

@bkd-newyork2256 9 ай бұрын

nice

@Charlie888 Жыл бұрын

@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 kzfaq.info/get/bejne/pd6JhJV4rMvKoqc.html (exact time 3:22 ) Please confirm your understanding. Thanks a lot Very informative video on RSL.

@Lotaristo 10 ай бұрын

It's not supported (read in official documentation)