Implementing ROW LEVEL SECURITY - STATIC vs. DYNAMIC RLS

Implementing ROW LEVEL SECURITY - STATIC vs. DYNAMIC RLS | Power BI

Рет қаралды 4,692

Жыл бұрын

Lets understand what is RLS and how to implement basic STATIC RLS vs. implementing more advanced DYNAMIC RLS.
1. What is RLS
2. Implementing STATIC RLS
3. Implementing DYNAMIC RLS
Data Used
www.kaggle.com/datasets/themr...
Visit my blog for more content :
www.pivotalstats.com
Cool tech I use to produce these videos (affiliate links)
1. Blue Yeti Microphone -
amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor -
amzn.to/3EaHY8v
#Microsoft
#powerpivot
#dataanalytics
#dataanalysis
#powerbi
power bi row level security,power bi,row level security in power bi,row level security,power bi tutorial,power bi desktop,power bi tutorial for beginners,power bi training,dynamic row level security in power bi,power bi rls,power bi for beginners,dynamic row level security power bi,power bi dashboard,power bi row level security userprincipalname,rls in power bi,row level security power bi desktop,power bi desktop row level security

Пікірлер: 27

@contactsaurabhsomani 10 ай бұрын

OMG!!! I was looking for this trick for over an year. Thank you!

@pivotalstats 10 ай бұрын

Happy to help! 🙂

@Sanj20101 2 ай бұрын

Watched many videos for RLS security but this one was awesome and easy to understand. Thank you bro. Keep it up. Learned lot of things from you

@pivotalstats 2 ай бұрын

It's my pleasure. Thanks for watching!

@akupatichiranjeevi6159 6 ай бұрын

In addition to my previous i wnat to add one more thing is 1.your voice is very crystal clear 2.plese keep on doing more videos on Complex DAX 3.Deployement pipeline also sir

@pivotalstats 6 ай бұрын

Thank you! Sure I will try to bring some videos on deployment as well. Checkout the full DAX masterclass video - kzfaq.info/get/bejne/athzbLKonJzSYIk.htmlsi=94dRzhhuLyHLxAtX

@MuhammedSwalihT 3 күн бұрын

Nice 😊👍🏻

@pivotalstats 3 күн бұрын

Thanks 😊

@princemurali5509 6 ай бұрын

Excellent explanation sir.💥💫

@pivotalstats 6 ай бұрын

Thanks buddy!

@Resh_Aadil_AllaboutExperience 5 ай бұрын

Great explanation👌👌👌

@pivotalstats 5 ай бұрын

Thank you 😃

@rajpadwekar5974 9 ай бұрын

Very informative video! I was wondering if RLS would be implemented on the entire report, i.e all the three pages as shown in the video?

@pivotalstats 9 ай бұрын

Yes, RLS will be applied on the entire report.

@premkumar-on8ko 3 ай бұрын

very helpful video, could you publish power bi services video , like deployment ,data mart , gateway , how to create mobile app.

@pivotalstats 3 ай бұрын

Yes sure, ill plan something for future videos!

@akupatichiranjeevi6159 6 ай бұрын

Very informative video. No doubt about it only issue is that background music and after publishing it to service don't we need to add the requirement?

@pivotalstats 6 ай бұрын

Thanks for the feedback! I have resolved that background music issue in my latest videos. Hopefully it will not be a problem going forward. If you are using Dynamic RLS then you define the roles in the PBI desktop and don't have to setup anything on the services. Hope I answered your query!

@ZOOTOPIAAAA 8 ай бұрын

hello !! is it a good idea to create primary and foreign on the table,,, some times many to many relationship cause different result in the report,,

@pivotalstats 8 ай бұрын

While applying RLS, you would often be in situation where many-many relationship is required. So I think its a good tool to have. However in all other scenarios, I personally try to avoid using many-many relationships.

@remembernaveen30 9 ай бұрын

Thanks for great video :) , My query is the user level needs licesnce to view the dashboard ?

@pivotalstats 9 ай бұрын

If you have a premium license then user can use without license. Otherwise user will also require license to see the dashboard online.

@remembernaveen30 9 ай бұрын

Thanks for kind reply .i want to have Power BI Premium per capacity (includes Microsoft Fabric) or Power BI Premium per user@@pivotalstats

@SKumar-tw8jj 4 ай бұрын

If I have many datasets so how can give separate report wise permission

@pivotalstats 4 ай бұрын

So if I understand you correctly, you have multiple dataset and each dataset is used to create a different report (different Pbix files). Then in this case each Pbix will have a separate RLS. So it will work just fine. However if you are asking how to give different permission to multiple datasets in the same pbix file then I think you can do it by creating multiple User Role tables and connecting them separately with each of your dataset. for ex: UserRole1 >> Covid_India ; UserRole2 >> Covid_USA. Hope it helps!